Home

EnergyReporter EXT User Manual V.1.03

1. ng View Monthly Data Customer ID 12457 Location Name Building 6 View bill errors Address 502 Juniata Gap Road Alttona PA 16601 a 1 Executive Summary Usage HEN Next Bill Date 11 1 2013 Renort e Click on a channel to view the errors in the meter data records Follow the instructions in Section 6 1 7 to correct errors NOTES Errors can only be corrected from the EnergyReporter Settings Editor e Typically the errors in DEMAND and INTERPOLATE I NTERVAL are caused by the problems in the Root Commodity value Correct that value before checking the others e f the Period contains no data the Monthly Utility Bill icon is greyed out and displays the message Unable to generate monthly bill too many records missing from period This happens if you have less then 2 days worth of data 3 While the Bill is being generated the progress is displayed in a screen NOTE You can generate multiple bills for a single bill period so if you click the Generate Monthly Bill for Selected Bill Period icon twice you will generate two bills g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 5 22 5 Step 5 E Billing Dashboard Viewer 4 Once the bill is generated it opens in your screen See the example bill below Provider Information Greater Altoona Realty Corp 10 W 8th Street 555 980 4785 Suite 300 Altoona PA 16601
2. Customer Information Total Summary Account l Electricity Charges 19 527 44 College Park Apartments 1 College Park Drive Altoona PA 16601 TotalDue Total Charges 5 527 44 Due Date Due Date 11 14 2014 Customer l Statement Date 10 31 2014 Bill Period 7 1 2014 7 31 2014 31 Days Total Due 19 527 44 Usage Chart Location Building 1 Meter Usage Electricity Charges kWh EN 2 NEN 2014 Meter PREV PRES Usage 1500 NJD N A N A 175 10000000 1800ShamesDr 186008 206126 20118 Office DS 203 252 50 iiaia Office JK 29 38 9 Office JS 203 252 50 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Mov Dec Office RK 1401 1578 177 Office RM 229 293 64 Office RP 68 83 16 Shark200 Unit9 40039580 53035912 12996332 Total 13016989 Itemized Charges Rate Structure Electricity Season Two Holiday 433198 8 0 0015 649 80 Season Two Off Peak 3414425 d 0 0015 5 121 64 Season Two On Peak 9169366 0 0015 13 754 05 Usage 0 01 1 95 Total Electricity Charge 19 527 44 Total Due 19 527 44 Provider Notes Thank you for your prompt payment NOTE If this bill was generated from Interval Energy data there will be no PREV ious or PRES ent usage values Remittance Address Send Payment To Greater Altoona Realty Corp PO Box 3452 Altoona PA 16601 3452 Page 1 of1 i Electro Industries Gauge Tech Docs E167701 5 23 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer
3. a Reports generated successfully 7 7 Click the OK button to close the message window Another window opens asking if you want to view your report See the next section 5 3 2 1 View Usage Reports When you generate a Usage report you have the option to view it right away Would you like to wiew the report now Ce Ge Click Yes to open the report See the sample report in Appendix A i Electro Industries Gauge Tech Docs E167701 5 18 The Leader In Power Monitoring and Smart Grid Solutions 1 To view Usage reports at any time click Reports View Usage Reports See the example screen shown below Usage Reports Luc JTI Save Report View Report Options 15 C kWh January 2014 15 C kWh February 2014 15 C kWh March 2014 15 C kWh April 2014 15 C kWh May 2014 15 C kWh June 2014 E Sample Customer E kWh Sample Customer kWh October 2013 Sample Customer kWh November 2013 Sample Customer kWh December 2013 Sample Customer kWh January 2014 Sample Customer kWh February 2014 Sample Customer kWh March 2014 January 2014 February 2014 March 2014 April 2014 May 2014 June 2014 October 2013 November 2013 December 2013 January 2014 February 2014 March 2014 Statu Repo Repo Repo Repo Repo Repo Repo Repo Repo Repo Repo Repo 5 Step 5 E Billing Dashboard Viewer 5 rt Generated 5 7 2014 rt Generated 5 7 2014 rt
4. E p e LL L 5 Lo ee Ln nl o o en LL 1 LL L5 DL o F LL 1 a 1L M L Licini L ct E e Lii DE E Ln Lond a L L LLL d as 9 O Ll L i ea E E Lm OL L L L ES SS EUREN URDU SS E UNE URSI li LL 1L LL 1 L ee LL 1L pp ee Ln L L VG Ll 1L 5 LL LL 5 ee Loi ii LL 1 a LL DL 1 LL 1L L 1L L L T Tc Ll cll cL Jit Li i i L LL 1 L L LL LL ee s LL L1 LL 1L pL 5 L5 DL L L EE o ee Lo L n a ao LL 1L pL Ll J a e e OO S a a C O OO Wu FT OH 6 00 3 00 m Bo oo JE o LLL LL AA Lue ALL LT MAMA j gt ET j Aug 2014 Main Building Total usage during Peak day EIG Engineering August 2014 Usage Summary Report Main Building 1800ShamesDr Average Hourly and Daily Usage Displays the average usage over the course
5. 5 4 2 Generate Bills Manually Bills are generated manually from the EnergyReporter Dashboard Viewer When a bill is generated the software analyzes the usage data for the meters at a location and applies the configured rate structure to that data A bill is always generated for a bill period which is the date range from the billing date of the previous month to the billing date of the current month A bill period need not contain a full month s worth of data a bill can be manually generated if there is at least two days worth of data Generate All Bills 1 From the EnergyReporter Dashboard Viewer main screen click the Generate All Bills icon 2 While the software is scanning for bills to generate the list of periods found so far are displayed You can stop the scan at any time to generate bills from the list of values scanned so far to do so click Cancel 3 When scanning is done or after you ve clicked Cancel the list of available periods is displayed See the screen shown below Bill Period Generate Status EI Building 6 5 1 2013 to 6 1 2013 7 OK 7 1 2013 to 8 1 2013 Ok 8 1 2013 to 9 1 2013 Fal OK Select the checkbox for the bills to generate Ifthe bill has already been generated or there are errors with the bill data then the bill has already been deselected for generation 4 Select which periods you want to generate bills for by clicking in the Generate box By default all periods which hav
6. Displays a comparison of daily usage between this month and last month and this month this year and this month last year The daily usage is lined up by week day for each month The numbers at the bottom indicate what day in the month each bar represents The top value is the current month the bottom value the month being compared against Figure 3 5 Comparison to Last Month aligned by weekday BENE August 2014 E July 2014 kWh usage per Day oL LL TETUR ee Do E I JI ELTE IL I DLL Lc a a A ee ILI DLL LT a E a Ft ft LL Il Il Il Sete 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Comparison to Last Year aligned by weekday EE August 2014 BN August 2013 kWh usage per Day Meter 1 Usage comparison to previous month and year EIG Engineering August 2014 Usage Summary Report Main Building Cubicle 1 Monthly Usage and Temperature Displays a comparison of monthly usage and temperature The highest and lowest temperature for each day over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 3 6 Monthly Usage and Temperature BEN Usage Per Day Max Temperature Min Temperature cn e KAIL i 4 5 a Y V HINE Titi 3 5 i S Es E BERRRRR RR d D l g MON E on n f 3 NMENTI
7. Next 4 Use the options shown above to handle the erroneous data e New Value if you know what the value should be enter it in this field If the value is wrong but you don t know what it should be use Interpolate see infor mation below Update after entering a new value click this button The next error if there is one is displayed Update uses the new value for the error record It doesn t clear the error though so if the new value is wrong it will still be an error nterpolate if you don t know what the value should be click this button to have the software calculate the new value for you The software can only do this if there are enough intervals before and after the error for it to compute the value from Clear Error if the error is not something that you can correct by entering a new value e g missing data click this button This flags the value as valid and tells the system that you want to use this value to compute reports e Previous to view the error before this one click this button e Next to view the error after this one click this button 5 Click the Commit button to save all your changes The software re analyzes the data and presents the results in the Scan and Edit Errors screen If all the data is good the screen should show no errors 6 If you have any more errors to correct click Filter to re display the selection fields on the right side of the screen and then
8. Nexus 1500 N 8 6 201211 54 AM Configuration sett Retrieved Logs 2 7 2010 5 12PM Text Document 14 items k NOTES The log database file comes from either the Communicator EXT 4 0 application db or dml the database created when logs are retrieved using the Commu nicator EXT 4 0 application or the HMI EXT application dbf the billing data database created by the HMI EXT software see that software s documen tation for details i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings e See Section 6 1 for file importing suggestions WARNINGS Be careful when selecting the location to import from Importing is done by the EnergyReporter Settings Editor software and if you select a loca tion that is not accessible or invalid you may not be able to import the data f you change the import location file it will wipe out the selected channels You will have to select the channels you want to import again 3 When you find the file you want to use click Open The screen closes and you see the Edit Meter Information screen The log file s path is now displayed on the screen next to Import Location 4 Once you ve selected the file to import from the application will verify that it contains log items that can be linked to commodities This includes Energy e g
9. EnergquReporter EXT Energy Dashboard Energy Reporting amp Cost Analysis Software Version 4 0 rp mrt es t enn i um rne TAN n Wi i a A o ta E o per fo a o User Manual V 1 03 October 29 2014 Electro Industries Gauge Tech y The Leader In Power Monitoring and Smart Grid Solutions a 1800 Shames Drive Westbury NY 11590 Tel 516 334 0870 Fax 516 338 4741 Email sales electroind com This page intentionally left blank EnergyReporter EXT Installation and Operation Manual Version 1 03 Published by Electro Industries GaugeTech 1800 Shames Drive Westbury NY 11590 All rights reserved No part of this publication may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying record ing or information storage or retrieval systems or any future forms of duplication for any purpose other than the purchaser s use without the expressed written permission of Electro Industries GaugeTech O 2014 Electro Industries GaugeTech Nexus and Shark 8 are registered trademarks of Electro Industries GaugeTech The distinctive shapes styles and overall appearances of the Nexus amp 1500 meter and the Shark meters are trademarks of Electro Industries GaugeTech HMI EXT and Communicator EXT are trademarks of Electro Industries GaugeTech Microsoft Excel and Windows are either registered trademarks or tr
10. The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 2 4 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT Meter Name Meter Type El Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Substation 3 Shark 200 Shark 200 Mexus 1272 Nexus 1252 Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Online Status Next Action Sais 2212014 12 00 P Online X 4 29 2014 12 00 PM Online 4 29 2014 12 00 PM Online 4 29 2014 12 00 PM Online X 4 29 2014 12 00 PM Online 4 29 2014 12 00 PM Online 4 29 2014 12 00 PM LUC neni 2272014 12 00 PM Online 4 29 2014 1200 PM Doc E167701 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT 2 2 Manually Connect to Meter To manually connect to a meter you enter the meter s IP address Tools Help mm ACTED 2 Des E ME E sw ah a Meter List Configure Meter Configure Scripts Script Status Auto Scan 4 IL DDD OOO o isa Enter New Meter Connection 2 Click Connect Manual Connect Settings 1 Enter meter s Connection Type IP Address 40001 00000 IP address Port Protocol Modbus address Port 502 Protocol Modbus TCP Y Modbus Address 1 Manual Meter Setup Screen Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterM
11. Total Watt hours and pulse accumulations e g a Digital Input channel 5 If you are using a Communicator EXT 4 0 log database click the Import Settings from Meter Log File icon this function is not applicable to HMI EXT databases You will see the message window shown below It tells you that the meter settings were imported from the meter with the serial number listed in the screen Click OK to close the window NOTE The Import Settings function will only fill in a meter name that has not already been entered If you have already filled in the meter name it will leave that as is TIP EIG highly recommends importing all the meter configuration data This automated tool makes the meter configuration task much simpler i Electro Industries Gauge Tech Docs E167701 4 49 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 6 Click the Apply icon to create the meter The Edit Meter information screen re dis plays with additional options now you can choose the channels to import See the example screen shown below Edit Meter Information Meter Name Nexus 1500 Meter Serial 000000004 7380527 Meter Type 0154 Nexus 1500 Import Location C Users Public Documents Electro IndustriesiCommunicator Extiketrigved Logs Nexu Select Import Settings to automatically import the meters settings from a CommExt log database Commod
12. ag Electro Industries haugeTech Docs E167701 4 34 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 4 3 Set Up a Customer Next you set up customer information The customer is the person who will be receiving the bill from the provider The customer can have one location or multiple locations The software will generate a bill for each location for this customer 1 From the EnergyReporter Settings Editor main screen click the Add Customer icon You will see the screen shown below but there will be an Apply icon in place of the other icons o Edit Customer Information Customer ID 1234 Customer Name College Park Apartments Address 200 College Park Drive Altoona PA 16601 Telephone 789 943 2789 Email Email Address cpa gmail com Report Email Settings Bill Report Disabled Default Configure Usage Report Disabled Default up T Add Location to this Customer Remove this Customer 2 Enter the following Customer ID enter a unique identifier for the customer which will be used to identify this customer e Customer Name enter the customer s name this does not have to be unique Address enter the customer s billing address Telephone number Email Address Report Email Settings after you click Apply you will be able to set up this field i Electro Industries Gauge Tech Docs E167701 4 35 The
13. f you want to change the Subject and Body fields for this customer s usage report and or bill report a Click the Default button to disable the default setting b Select Bill Report or Usage Report from the Report pull down menu The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 4 36 4 Step 4 Configure the E Billing EXT M Application Settings c Enter the Subject and Body text you want to use d Click the Enable checkbox D Repeat these steps if desired for the other Report option f Click OK to close the screen 5 Click Add Location to This customer and continue to the next section 4 4 Set Up a Location and Add Meters to It Once you have set up a customer you enter the customer s billing locations A location is the physical address the actual location that is consuming the power or other commodity e Customers can have multiple locations They can also have a rate structure for each commodity being billed for at a location e g Energy and gas e Each location can have one or more meters attached to it If there is more than one meter the software creates a virtual aggregated meter that stores the composite usage data of all the location s meters Whenever a meter data import is performed the Aggregated Meter is updated with new usage data for all the meters at that location The Aggregated Meter is displayed on the main screen of the
14. NOTE You can also select Create New to add a new rate structure Follow the instructions for adding a rate structure in Section 4 2 4 4 1 Adding a Meter Manually The usual and preferred method of adding meters to a location is through the meter list as shown in the previous section If you need to enter a meter manually follow these instructions 1 From the Edit Location Information screen click the Add a Meter to This Location icon The Edit Information screen opens Enter the following Meter Name enter a unique identifier for the meter This name must be unique across all locations It is used to identify the meter s billing data i Electro Industries Gauge Tech Docs E167701 4 47 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings e Meter Serial enter the meter s serial number e Meter Type enter the meter type Nexus or Shark amp 2 Import Location is the place where the meter s billing log data is stored e g C Users Public Documents Electro ndustries Communicator_EXT Retrieved Logs This log data file contains the raw values the EnergyReporter EXT application imports in order to generate its billing database i e Energy usage or pulse accumulations Refer to Figure 4 1 for a depiction of the data flow between applications see Chapter 2 if you need to refresh your understanding of setting up the meters historical logs for
15. You can view this log through the Action Log Viewer which is available from the EnergyReporter Settings Editor In addition errors can be viewed and corrected from the Action Log Viewer 1 From the EnergyReporter Settings Editor click Tools2 View Action Log See the example screen below E Action Log Viewer eB T4 e View By Date Time H S Show All Actions Action Date Time Location i T m Customer ID 1234 11 1 2013 10 58 AM 1234 at Buildin m Location ID Building 4 Import 11 1 2013 10 58 AM 1234 at Buildin ee Meter ID 1800ShamDr Report 11 1 2013 11 02 AM 1234 at Buildin Report 11 1 2013 11 02 AM 1234 at Buildin Report 11 1 2013 11 10 AM 1234 Report 11 4 2013 12 15 PM 1234 at Build Description eas Fd NATU HN E n E Users nd Desktop Framemaker E Report 11 1 2013 12 15 PM 1234 at Buildin Software E Billing EXTidemo logs Report Error 11 1 2013 12 15 PM 1234 at Building Action Import 11 1 2013 5 20 PM 1234 Source File C Users ndeibler Desktop Framemaker Softw 114 2013 5 21PM 1234 114 2013 6 13PM 1234 Import Start unspecified Import End unspecified Error Message 2 The actions are shown in the left side of the screen Any errors are shown in red 3 Click on an action to display information about it in the right side of the screen 4 To display options right click on the action or error f you right click on an action you can select to Repeat the action e g
16. another field opens up on the screen for you to enter the Custom Scalar value The scalar you select is applied to the commodity s usage values for all of the meters This is important because the meters themselves may have been set up with different scaling values The scalar insures that the usage values will all be scaled the same way in the EnergyReporter EXT applica tion When you are tracking usage other than Energy a custom scalar can be used to change the unit measured For example if you are tracking Con densate steam the meter s pulse accumulator channel i e Digital Input records the number of pulses coming from the Condensate meter which is measuring the steam directly But you may need to convert the pulse accu mulation value to MMBTUS for your billing In this case you would use the scalar to convert the number of pulses to the MMBTU usage value See the figure and example screen on the next page i Electro Industries Gauge Tech Docs E167701 4 10 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Pulse Accumulation Measurement Example This example converts measured condensate to MMBTU s Measured Steam Pulses are counted by meter Meter s Digital Meter with Outputs Pulse Output Pulses input Import Log Data Pulse Accumulator y EnergyReporter MMBTU EXTApplication Commodity Pulse Values
17. or other means designed to circumvent or remove the License Manager You may not utilize any equipment device software or other means designed to circumvent or remove any usage restrictions or to enable functionality disabled by EIG in connection with the SOFTWARE You may not bypass or delete any functionality or technical limitations of the SOFTWARE that prevent or inhibit the unauthorized copying or use of the SOFTWARE viii Export You may not export the SOFTWARE in violation of this Agreement or U S or other applicable export control laws 2 LICENSE KEY The SOFTWARE is protected by a lock and may only be used in con junction with a valid License Key which may be either a hardware or software device issued by or on behalf of EIG EIG retains ownership of the License Key You may use the License Key to operate the SOFTWARE for the term of this Agreement 3 COPYRIGHT The SOFTWARE is owned by EIG and is the subject of copyright You may be held legally responsible for any copyright infringement which is caused or encouraged by your failure to abide by the terms of this Agreement You must not copy or duplicate the SOFTWARE the License Key or any written materials except as expressly provided for in this Agreement EIG has the right to trace serial numbers of the License Keys at any time and in any reasonable manner 4 USE RESTRICTI ONS You may physically transfer the SOFTWARE from one com puter to another provided that
18. re import data if the action is Importing Electro Industries hauge Tech Doc E167701 Tal The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions e Acknowledge All Errors they won t show in red anymore Delete Selected Actions remove the action from the action log Hide Details Show Details this option toggles between hiding or display ing the detailed information on the right side of the screen f you right click on an Error you have an additional option Mark as Acknowledged Error Mark as Unacknowledged Error this option toggles between acknowledging the error and removing acknowledge ment of the error 5 The options at the top of the screen let you E Action Log Viewer ur View By Date Time HN D Show All Actions Refresh Details Viewing Sort Order Acknowledge FAL Re Import Choose Actions All Errors to XML to Display EI Rl Clear All Clear Selected Actions Actions Refresh the action display by clicking the Refresh icon Select the order of action display by clicking in the View By pull down menu The choices are Date Time the default setting Customers and Action Type Acknowledge all Errors by clicking the checkmark icon e Export to XML by checking the document icon this copies the action log in XML format you can then paste it into an XML file e Re import meter data by selecting the two arrows icon The Lead
19. Bill Settings Editor in the Location tree E EnergyReporter EXT Settings Editor File Configure Tools Help D Lj B Add Edit X Edit Import Customer Rates Provider All Logs Customers a Locations fs Building 1 Meters amp Aggregated Meter Aggregated Meter 50 ND 1800ShamesDr Office Ds Physical Meters Office JK Office ss Office RK amp Office RM amp Office RP Be Shark200 Unit9 i Electro Industries Gauge Tech Docs E167701 4 37 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings 1 When you click the Add Location to This Customer icon you see the screen shown below Use this screen to set up information for the billing location e TATI mos Edit Location Information Location Name College Park Apartments C i ck to Bill Period 6th of the month iii select Bill Location Address 200 Wopsononock Avenue Pe ri O d Altoona PA 16601 Weather Data Settings Configure Press apply to save changes Rate Structure Apply Values Changed 2 Enter a unique name for the location in the Location Name field 3 Click Edit next to Bill Period to select a billing period The billing period is the day of the month on which the bill is computed Select the bill period 1 Day of the Month OK 4 From the pull down menu select the day of the month you wa
20. Click OK to proceed with the shutdown NOTE The local database server does not close when you exit the Ener gyReporter EXT application You must use this command if you want to close it e Start click this button to start the main Database server not the local database server if it is not opening correctly it should open when the software starts Electro Industries hauge Tech Doc E167701 7 9 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 2 6 DB Actions 1 From the Database Maintenance screen click the DB Actions tab Archive Databases Restore Databases Db Actions 2 You have two options e Clear Data click this button to clear all meter data Clear Reports click this option to clear all report data Electro Industries hauge Tech Doc E167701 7 10 The Leader In Power Monitoring and Smart Grid Solutions 7 3 Clear Meter Data 7 Additional Features and Advanced Functions The EnergyReporter Settings Editor gives you the option to clear meter data You may want to do this if you imported the incorrect data or corrupted data and want to remove it 1 From the EnergyReporter Settings Editor Location screen highlight the meter whose data you want to clear See the example screen below B EnergyReporter ExT setings tr TC tw oleh File Configure Tools Help o 0 Lj M i Add Edit Edit Import Dashboard C
21. E167701 vi The Leader In Power Monitoring and Smart Grid Solutions c EIG warrants that if the License Key is a physical device it is free of defects in manufacture under normal use A defective physical License Key may be returned upon authorization by EIG to an authorized EIG distributor who will replace the License Key without charge unless the item has been damaged by accident or misuse d To the full extent permitted by applicable law any conditions or warranties imposed or implied by law are hereby excluded Insofar as any such provisions cannot be excluded then to the maximum extent permitted by the law liability for breach of any implied condition or warranty is limited at EI G s option to either the repair or replacement of the SOFTWARE or the License Key e In no event will EIG be liable to you for any loss damage or expense of any kind whatsoever consequential upon or otherwise arising out of its supply of the SOFT WARE or the use of the SOFTWARE by You or any other person This warranty does not cover problems caused by Your acts or failures to act the acts of others or events beyond EIG s reasonable control f No oral or written information or advice given by EIG its dealers distributors agents or employees shall create a warranty or in any way increase the scope of the warranties above and You may not rely on any such information or advice g Disclaimer The limited warranty is the only direct warranty
22. EnergyReporter EXT application use Click Browse to locate the meter s log database file You will see a screen that lets you locate and select the log file See the example screen shown below O Jod gt Computer OS C Users Public Public Documents Electro Industries Communicator Ext Retrieved Logs gt Organize v Include in library v Share with v Burn New folder R Links e Name Date modified Type Ji My Backup Files E My Documents Electro Industries J E Billing Ext J GE145751 dsgn di MAGIX Downloads Ji MAGIX Screenshare J SightSpeed Recordings J Backup Logs 6 1 20128 51 AM File folder J CSVRECS 2 27 2012 5 44 PM File folder J HHF Files 2 201210 17 AM File folder J log archive 2 2012 10 17 AM File folder Jy Nexus 1500 N 0000000047380527 6 1 20129 16 AM File folden 8 1272 IP73 3 1 2012 1 48 PN Data Base File JMR IPREM D 9 22 2010 2 16 PM EBM DE File amp 1272 1P73 3 1 2012 1 43 PN Configuration sett n Snagit 4 Dina Paintings 4 Errans Pics INTERVAL 1 nexus 1500 n 2 amp Nexus 1500 N Data Base File Data Base File Data Base File d FW Fonts and logo 4 Neena Deibler pics 4 pics 10 16 2011 n My Music E My Pictures E My Videos Saved Games KE Searches B Virtual Machines jl Computer amp OS C de DVD RW Drive D BuffyScreenSaver Debe Deb 0 _ Nexus 1500 N EBM DB 6 1 2012 8 51 AN EBM DB File amp
23. From Meter 3 a Settings Editor Reports Doesn t require setting up Any services or extra users Figure 1 1 Local Database Server i Electro Industries Gauge Tech Doc E167701 1 8 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application Import Data From Meter PC Viewer D Multiple PC s can access the EnergyReporter EXT Reports and Data Server Settings Editor PC Viewer qc Figure 1 2 Network Database Server i Electro Industries Gauge Tech Doc E167701 1 9 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 6 Click Next You will see the screen shown below Enermyfeporter Ext 40 Setup O cit Choose Component E Choose which features of EnergyReporter Ext 4 0 you want to install Fy Check the components you want to install and uncheck the components you don t want to install Click Install to start the installation Description Select components to install Settings Editor E E LISS LILI H LILI Ose Bill Viewer Over a comp n Database Server see its description Space required 36 4MB Nullsoft Install System v2 46 This screen lets you choose the application components you will install on the PC f you are setting up this PC as a Viewing Client only not able to make changes to settings check only the Bill Viewer box f yo
24. KWh usage 0 055 0 050 0 045 Aug 2014 0 060 0 075 0 070 0 065 0 060 15 minute trend of KWh usage o LC TET AES 0 050 0 045 m NN N dl m t Fri 8 3 00 6 00 9 00 12 00 15 00 18 00 21 00 Sat 9 Aug 2014 Meter 1 Total usage during Peak day EIG Engineering August 2014 Usage Summary Report Main Building Cubicle 1 Average Hourly and Daily Usage Displays the average usage over the course of the month averaged by hour and by weekday The highest and lowest usage for each hour and weekday over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 3 4 Average Hourly Usage Min Usage BN Average Usage Max Usage 08 08 2014 13 00 00 am F 4 ao o o gt gt E i a 1 E i E C LI a Mi 01898 08 23 20 14903 00 m m NM NM NM NM NM NM NM NM NM NM NM NM NM NM NM NM H 12 00 AM 3 00 AM 6 00 AM 9 00 AM 12 00 PM 3 00 PM 6 00 PM 9 00 PM Average Weekday Usage BN Average Usage Max Usage Min Usage L FEE Max 0 303 08 08 2014 13 00 as cC 1 1 B i i 1 e g i i pi 1 1 pu r 1 l a cC m E Ea Sunday Monday Tuesday Wednesday Thursday Friday Saturday Meter 1 Average hourly and daily usage EIG Engineering August 2014 Usage Summary Report Main Building Cubicle 1 Comparison to previous Month and Year
25. Ss o 2 2 2 o 5 o 2 5 o amp O oc Q E Q E QU baat on en en en im LLI Q a x 8 48 2 5 E e Q b 5 5 5 5 O ea ES 8 T cea cof N E O E wx ER e e e d IL 3 Cy O Q gt gt a B 5 sen c e x o a dm c oO O o 5 D o v9 o E CN N p R lt z z m ES c u LL Lu t E Q a O U s O m U m o a k Uo D Sl o O U x g 2 2 iD O go wl O D z c ps gt 5 ec oOo O o c E 2 E i E V Bd ol amp x 2 E DE E p E S en 9 Q A a ES o E E gt D S I em mmm 2 2358 5i 5 a o 5 c a5 op 2 mo lt L Q TE Q t Ss e eo ee LL ee q Ea on en eb O A o D i p 3 gt qu em O em o em a C 5 A 5 3 gis od jf iK Ez Lu Un g uz Dor LT LS E S Egg B EBDE E E E Bs OF gt Oz O e n0 wx e Oo tT o N e ia O m gt Aeg Jad abesn uA gt Aeg Jad afesn ua gt t 2 U o b ra U Z Lp oJ Eo SR E DR RR RE RR Figure 1 1 es es ee ee 1 Ss M m wt se ee ee LN IATA rrr rtr PORRA FORA rrr rrr rrr rrr dcr E CEP LLL LLL N io 9 MO C C Oc Oo rm YW t 0 N aBesn UA JO pua aynulw S Demand otal Usage k Usag k Q o Main Building Aggregated Meter Total Usage during Month 08 01 2014 to 08 31 2014 p e p p 3 3 A o 50 S un o e EA S 50 z lt EIG Engineering Agg
26. Three September 21 E E E El Season Four Season Four December 21 Enter Name Select End for the Date for the Seasons Seasons Store a Click in the pull down menus to display a calendar you use to select the end date for each season This is the last day the rates for that season are applied to usage b In each entry field to the right of the season specify the name to show on the bill for that season i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions Rate Calendar Rate Structure 4 Step 4 Configure the E Billing EXT Application Settings Name Electricity 2 Commodity kWh Yv Number of Seasons Two Seasons v Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Rate Calendar Monthly Rates October 2013 10 10 2013 v Sun Mon Tue Wed Thu Fr Sat 18 B oH 4B 5 TE om om a 2 1 KR 1 ads E i 28 75306 534 Legend E Holiday Season One Off Peak E On Peak Season Two Off Peak E On Peak Daily Rates Thursday October 10 2013 Season One 00 00 Rates Rate Charge per unit Off Peak 0 025 E On Peak 0 035 Review your rates on the rate calendar to make sure you have everything set up correctly 5 Click Store to save your rate structure Instructions for setting up a Flat Rate schedule follow If you d
27. Viewer File Reports Tools Help Location Information Location Specifics Locations Bs Mathers Building E do 12457 m 1 Click on a customer View Monthly Data Monthly Utility Bill 12457 Building 4 Customer ID Location Name Locations i Locations Address 400 Wopsononock Road p Altoona PA 16601 5 E ER Building 4 Em Exedutive Summary Usage m Next Bill Date 11 1 2013 Repdrt Bs Building D 2 Cli k Rates Electricity 2 E 14577 IC i a Meters 1 Usage Dashboard Locations location Bill Data Range 5 26 2013 9 28 2013 c 14678 Locations B db 17850 Previous Month Views Click Monthly Locations a Bill 9 1 2013 Bill Generated 11 1 2013 Utility Bill E au 29087 E Usage Report 9 1 2013 v Report not generdlid Locations a gy 34567 Select a bill Date the bill period was generated 2 Click the Monthly Utility Bill icon The software checks to see if the period you selected contains valid data e f the Period contains errors the View Errors icon appears see the partial screen below Click this icon to see a list all of the errors that prevent the bill from being generated Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 5 Step 5 E Billing Dashboard Viewer Help ge Dash board E Location Information Location Specifics
28. a customized date range View meter logs for meters set up using the MeterManager EXT Meter List Connect to the meter through Communicator EXT 4 0 software for meters set up using the MeterManager EXT Meter List Copy export or print graph image Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 1 To open the Usage Dashboard click on the Dashboard Viewer icon either at the top or the middle right of the EnergyReporter Dashboard Viewer screen a6 EnergyReporter EXT Dashboard Vi File Reports Tools Help Generate View Bills Usage Dashboard Settings Editor PA All Bills Customers E TT Location Information amp Locations EE Building 1 Location Specifics Bs Building 2 Customer ID 1 Location Name Building 1 Monthly Utility Bill Address 10 College Park Drive e BB View your monthly Utility bil Altoona PA 16601 Next Bill Date 11 1 2014 Executive Summary View Executive Summary and Rates Electricity Usage Report Meters 9 Bill Data Range 11 2 2013 10 8 2014 inge Bere ar ake J usage Previous Month Views Bill Bill Generated 10 9 2014 Usage Report Report not generated 2 The EnergyReporter Dashboard Viewer opens g6 EnergyReporter EXT Dashboard Vi File Reports Tools Help c i Generate View Bills ocation Info Settings Editor All Bills Customers rr Usage Dashboard T MAIN Month
29. and will not work NOTES e The licensed copy of the Communicator EXT 4 0 application only needs to be on the Server not the Clients for the MeterManager EXT application to operate however other features such as being able to use meter addresses other then 1 still require a Communicator EXT application license to be installed on the Client PCs as well B Electro Industries haugeTech Doc E167701 1 2 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application The MeterManager EXT application should be configured to download log data only from the Server not from the Clients The Clients will read the data from the Server PC The EnergyReporter EXT application must be run on a computer with one of the fol lowing operating systems e Windows 78 Professional Operating System e Windows 88 Professional Operating System Refer to the diagram below for a graphical representation of the way the software modules work together Meters Network E e E Ec Software Applications Communicator EXT 4 0 Database Application MeterManager EXT Automated Data Collection and Meter Management Energy Reporter Settings Editor EnergyReporter EXT System Server Includes EnergyReporter Dashboard Viewer Network Connection Client PC EnergyReporter Dashboard Viewer Only Communicator EXT 4 0 Figure 1 1 Relationship of Software Applications i Electro Ind
30. data on the database server Using this to restore to a server will overwrite all data WARNINGS A database archive can be extremely large For example a database with hundreds of meters with data accrued for a few years can be at least 20GB in size Make sure you have the room to store the archive e Only the data stored on the server is saved The server s settings and configuration must be manually re configured when the data is restored 1 From the Database Maintenance screen click the Archive Databases tab This archives the entire database cluster so you can later restore it if a problem occurs Select the location fo archive to and click Begin Archive Location Archive to single file 2 Click the Browse button to choose the location you want to save the archive to 3 To save the database to a single file leave the checkbox selected This option makes it easier to store and transfer the archive but may cause problems for older operating systems Dock E167701 7 5 g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions WARNING You should disconnect the database so that no one else can modify it while you are performing the archive Otherwise the archive may be corrupted 4 Click the Begin Archive button You will This may take a long time for large databases Please be patient and do ri g
31. decreasing but n Previous Clear Error Next 1700ShameDr 6 10 2013 6 00 PM Counter values decreasing forr Error Interval value decreasing but no rollover detected This could indicate an 1700ShameDr 6 24 2013 8 45 AM Interval values are missing in th energy reset or a gap in data 1700ShameDr 7 15 2013 8 30 AM Interval values are missing in th 1800ShamesDr 6 10 2013 5 45 PM Interval value decreasing but n 1800ShamesDr 6 10 2013 5 45 PM Interval value decreasing but m 1800ShamesDr 6 10 2013 6 00 PM Counter values decreasing for r E Suggestion Decreasing values most offen occur because of time changes If this is the case clear the error toficontinue If this is not the case determine if the source data is correct Before continuing 4 m p Commit Suggested way to handle the error Information about the error e The top right of the screen displays the timestamp and value of the erroneous data and the timestamps and values around it to help you diagnose the error and decide what to do about it e The bottom right of the screen gives information about the error and the suggested way to handle it i Electro Industries GaugeTech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data The middle right of the screen contains options you can use to handle the error New Value Update i Interpolate Previous Clear Error
32. from EIG EI G gives no other express warranties guarantees or conditions Where allowed by your local laws EIG excludes implied warranties of merchantability fitness for a particular purpose and non infringement 10 GOVERNING LAW This Agreement is governed by the laws of the State of New York United States of America regardless of conflict of law principles 11 EXPORT CONTROL The export of products software technology or information may be subject to control or restriction by applicable laws or regulations on the con trol of export notably the United States Export Administration Act and the regulations there under and the European Union Regulation 428 2009 applicable to dual use and cryptographic products and technologies You are solely responsible for determining the existence and application of any such law or regulation to any proposed export of the SOFTWARE by You or Your representatives and for performing any declaration or obtaining any required authorisation in relation therewith You agree not to export the SOFTWARE from any country in violation of any applicable legal or regulatory obli gations or restrictions on that export In the event the aforementioned legal or regu i Electro Industries Gauge Tech Doc E167701 vii The Leader In Power Monitoring and Smart Grid Solutions latory obligations or restrictions are violated by You or any of Your representatives in relation with the export of the SOFTWARE Yo
33. ht CI ick O K to conti nue not modify anything while the archiver is running see the message window shown on the Once you begin archiving the database the process won t stop until the entire database has been archived As the message says this can take a very long time so be patient 5 You will see a progress screen while the database is being archived and a message window once the archiving is successfully completed See the screen below Database archived successfully to C Users ndeibler Desktop Framemaker Software E Billing EXT 2012 06 05_12 31 57 dbc archive Click OK to close the message window 7 2 3 Restore Database Clusters If you ever need to recover from a corrupted database or if you want to move your database server to another location you can restore a database cluster from an archive created with the Archive Database tool WARNING Restoring a database archive overwrites all the data in the database cluster Any data already there will be lost NOTE Only the data stored in the database Is restored Any server configurations or back end changes must be re configured manually i Electro Industries Gauge Tech Docs E167701 7 6 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 1 From the Database Maintenance screen click the Restore Databases tab Archive Databases Archive Location Use
34. of the month averaged by hour and by weekday The highest and lowest usage for each hour and weekday over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 2 4 Average Hourly Usage GE Average Usage Min Usage 55 Max Usage 53 000 08 27 2014 15 00 00 F 41 4 4 9 I4 4 4 6w Average kWh hourly Usage PER eH EERE BEER PPro E 12 00 AM 3 00 AM 6 00 AM 9 00 AM 12 00 PM 3 00 PM 6 00 PM 9 00 PM Average Weekday Usage Min Usage Max Usage GE Average Usage 53 000 08 27 2014 15 00 00 4d 4d Jd 4l hd a eos mmm umm m mom omen a ee ee ee ae ee ES LU L 1 1 1 L T LI LU LU I L I t L 1 1 1 1 Average KWh weekday Usage sunday Monday Tuesday Wednesday Thursday Friday Saturday Main Building Average hourly and daily usage EIG Engineering August 2014 Usage Summary Report Main Building 1800ShamesDr Comparison to previous Month and Year Displays a comparison of daily usage between this month and last month and this month this year and this month last year The daily usage is lined up by week day for each month The numbers at the bottom indicate what day in the month each bar represents The top value is the current month the bottom value the month being compared against Figure 2 5 Comparison to Last Month aligned by weekday BEES August 2014 NN July 20
35. page can change or even destroy data 58000584 Closed stored on the database server Are you sure you want to continue 2 Click Continue to access the database options explained in the next sections Electro Industries hauge Tech Doc E167701 7 3 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 2 1 Database List To view existing databases 1 From the Database Maintenance List click the Database List tab this is the first tab displayed when the Database Maintenance screen opens so you may not need to click the tab to see it Server 127 0 0 1 Database settings User ID b Server 127 0 0 1 Database action history Use Server 127 0 0 1 Database security User ID b Server 127 0 0 1 Database action User ID billi Servers 127001 Database devices User ID b 2 This screen displays the status Open or Closed of the databases and information about them Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 2 2 Archive Database Clusters To ensure that your data is backed up or if you want to migrate the database server from one computer to another you can archive your database cluster This creates a local copy of the data which can later be uploaded to a server to restore the database to the saved condition NOTE This function copies all of the
36. period see step d Flat Rate select this to add a charge that applies to the total usage e g a Generation charge or Fuel surcharge This rate is multiplied by the total usage when the bill is generated Tax select this to enter a tax percentage that will be applied to the total when the bill is generated i e multiplied by the total dollar amount on the bill for the commodity and added to the bill Coincidental Peak Demand select this to compute the Peak Demand time from a meter at another location e g a Utility meter The time of the charge comes from the Utility meter but the charge is applied to the sum of the location s meter s usage See the example on page 5 18 i Electro Industries Gauge Tech Docs E167701 4 17 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Tiered Rate select Tiered rates to indicate charges that are dependent on the amount of usage during the Bill period For example a multiple tiered rate may be defined to encourage energy conservation by charging higher rates for customers that exceed what is considered typical consumption C For charge types Fixed Flat Rate and Taxed you must enter the Charge Name select what season s to apply it to from the pull down menu and enter the Rate or Percentage for Tax Charge Type Flat Rate Click to select fixed charge EE i Apply To Season All Seasons Click to
37. scaled from Condensate to MMBTU s y MMBTU Data To convert condensate to MMBTU configure the scalar for the commodity This value should be the value to convert 1 pulse to MMBTU For example if 1 pulse 1 kgallon of steam and 1 gallon of steam equals 8 2345 MMBTU then the scalar should be 0 0082345 Figure 4 2 Scalar Example for Commodities Other Than Energy Edit Commodity Information Name MMBTU Scalar Custom Infinity Custom Scalar 0 0082345 OK Cancel c Click OK to save your entries and close the screen click Cancel if you want to close the screen without saving your entries i Electro Industries Gauge Tech Docs E167701 4 11 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings The other settings for rate structure are as follows Seasons Setting Some utility companies bill their customers higher rates at different times of the year The reason for this is that it may be more costly for utilities to generate or buy electricity during peak seasons The Seasons setting lets you set up different rates for up to four different times of the year that you may need in your rate jurisdiction Select the number of seasons from the pull down menu If you select more than one season you will see a Seasons tab that you will use to set the seasons dates You use the Rates tab to set different On Pea
38. select season s Flat Rate Name DA CRS DWR bond Enter name Flat Rate 0 00505 Enter rate A Flat Rate is a charge which applies to the total usage such as a Generation Charge or a Fuel Surcharge The rate is multiplied by the total usage for the commodity g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 18 4 Step 4 Configure the E Billing EXT M Application Settings d If you select Peak Demand the screen changes as shown below Charge Type Peak Demand Apply To Season All Seasons Peak Demand Name Peak Demand Peak Demand Rate 0 00 Apply To holiday Season One Mid Peak Season One Off Peak Season Two Mid Peak Season Two Off Peak A Peak Demand Charge is a charge applied against the aggregate Peak Demand over the period of the bill The Name is the label that will be shown for the charge on the bill and the rate is multiplied by the Peak Demand to get the monitary charge The apply to rate is the rate rule which is concidered the Peak intervals Cancel The charge s name defaults to Peak Demand though you can change it if you want The name appears on the bill next to the Peak Demand charge e Select the season s to apply the Peak Demand charge to enter the Peak Demand rate and click the checkbox es rate periods you want the Peak Demand rate applied to You can apply it to Holiday Peak an
39. settings above are examples only e Database Type EIG is only supporting a PostGre database for its database type e Data Source the database server s IP address If the database is configured as Local Only see Section 1 2 1 step 5 make sure the Local Only Database check box is selected i Electro Industries Gauge Tech Doc E167701 1 15 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application Port the port to connect to the server on By default the port is 5432 which dis plays when you click the Default checkbox Requires Login Leave this box checked 2 Click the OK button to process your entries The software connects to the specified database 1 4 Enter a Software License Key When you first use the EnergyReporter EXT application you need to enter the soft ware license key that lets you use the full version of the application the Demo version lets you set up only one location and does not perform the automatic check for updates 1 From the EnergyReporter Settings Editor click the Upgrade License icon or click Help Upgrade User License Automated Energy Reporting Cost Analysis and Usage Billing MAIN MENU Add Customer Import All Logs Party who wil receive the bill Import your data logs to view Edit Rate Structures Dashboard Viewer Edit or Modify billing Rate Laul Launch the Dashboard Wiewer Fe z structures Edit Pr
40. single file archive This restores an entire archived database cluster This will delete the current contents and restore it fo a previously saved database Select a file or path and click Begin If the restore fails try restarting the server and restore again Begin Restore 2 Click Browse to locate the database archive you want to restore 3 If the archive was stored in a single file leave the checkbox selected If it was stored in multiple files uncheck the box 4 Click Begin Restore to restore the database You will see the message window shown on the right 5 Click Yes to continue You will see the message window shown on the right Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions r Restore Databases Restoring database clusters require deleting the old contents and inserting old data Are you sure you want to continue r Close Confirmation This will take a long time and this software cannot be running while the restore is under way so the software will shut down Are you sure you want to begin Dock E167701 7 Additional Features and Advanced Functions 6 Click Yes to continue You will see the message window shown on the right Key RESTORE in the blank field and click OK Type in RESTORE to confirm the restoration of all of the databases 7 While the database is being restored you wil
41. the csv file You can the copy the data into another application such as the Microsoft Excel amp applica tion or use it in your own applications The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 6 7 6 Managing Data 6 2 Edit Data Errors Following is the recommended procedure for correcting data errors for example zero values due to problems in communication 1 From the EnergyReporter Settings Editor Main screen click Tools gt Edit Data Errors You will see the screen shown below P Scan and Edit Data Errors Search Filter Timestamp Error Description Customerid EH Select the cus Location E tomer location l meter channel sim you want to see Any errors for 4 m p Filter Scan O a Click Scan 2 You use the fields on the right side of the screen to refine your search for data errors You can specify customer location meter and or channel or select Any which will display data errors for all of the entries in that field for example to see data errors for all of the meters at a location select the Location from the Location ID pull down menu and then select Any from the Meter ID pull down menu Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data 3 Click Scan to cause the software to begin looking fo
42. the SOFTWARE is used on only one computer at a time in conjunction with the License Key You may not modify adapt translate reverse engineer decompile or disassemble the SOFTWARE or the License Key or create derivative works based on the SOFTWARE or the written materials Electro Industries Gauge Tech Docs E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 TRANSFER RESTRICTI ONS In no event may you transfer assign rent lease sell or otherwise dispose of the SOFTWARE the License Key or the written materials on a temporary or permanent basis except by returning them all to EIG 6 TERMINATION This Agreement is effective until terminated This Agreement will terminate automatically without notice from EIG if you fail to comply with any provi sion of this Agreement Upon termination for any reason You must return all copies of the SOFTWARE the License Key and the written materials to EIG including all copies whether modified merged or included with other software and shall certify in writing to EIG that You have not retained the SOFTWARE in any form Termination of this Agreement pursuant to this clause does not affect any rights or remedies which EIG may otherwise have under this Agreement or at law 7 UPDATE POLI CY EIG may create from time to time updated versions of the SOFT WARE EIG may make such updates available to You only if you have a current SOFT WARE support contract for each SOFTWARE l
43. the agreement ENERGYREPORTER EXT LICENSE AGREEMENT This legal document is an Agreement between you as the end user of ENERGYREPORTER EXT software SOFTWARE and Electro Industries GaugeTech CER EIS licenses this SOFTWARE to You only upon the condition that you accept all of the terms contained in this Agreement BY SELECTING THE AGREE BUTTON BELOW THIS AGREEMENT OR BY INSTALLING UPLOADING ACCESSING OR OTHERWISE COPYING OR USING ALL OR ANY PORTION OF THE SOFTWARE YOU AGREE TO BE LEGALLY BOUND BY THE TERMS OF THIS A oma ee Irr If you accept the terms of the agreement cick I Agree to continue You must accept the agreement to install EnergyReporter Ext 4 0 Mullsort Install System v2 46 4 This is the license agreement for the EnergyReporter EXT application Use the scroll bar to view the entire document Please make sure you read and agree to the terms of our End User License Agreement then click Agree By clicking Agree you are agreeing to the full terms of this End User License Agreement Electro Industries hauge Tech Doc E167701 1 6 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application O EnerayReporter 64 40 Setup cle Choose Component Wiri Choose which features of EnergyReporter Ext 4 0 you want to install D Check the components you want to install and uncheck the components you don t want to install Click Install to start the i
44. things like hallway and outside lighting on a separate bill from the tenant billing To do this you would put 100 for the usage field for the submeters and 100 for the usage field for the meter attached to the utility feeder B Electro Industries haugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 46 4 Step 4 Configure the E Billing EXT Application Settings 18 When you have made your choices click OK The channel commodity and roll over value are now shown in the Channel Commodity Rollover box in the Edit Meter Information screen NOTE To edit a channel click on it in the box and click the Edit Channel icon to remove a Channel click on it in the box and click the Remove Channel icon 19 If you want to add a channel for another commodity follow the same procedure When you are done selecting channels click Store to save the settings NOTE This screen also gives you the option of removing the meter to do so click the Remove This Meter icon Removing the meter will delete all of the imported data for the meter 20 Click Exit to return to the Edit Location Information screen Add a rate structure to the Location by clicking the Add Rate Structure icon You will see the screen shown below Select Rate Structure to add to this loca Rate Structure Cancel 21 Select the rate structure you want from the pull down menu and click OK to close the screen
45. use the same rate structure 1 From the EnergyReporter Settings Editor main screen click the Edit Rate Struc tures icon Configure Rate Structures Rate Structures Electricity Locations that use this rate Customer Location Building 4 Building 6 Add new Rate Structure Edit the selected Rate Structure Remove the selected Rate Structure Edit Commodities 2 If you have already set up rate structures you will see those in the box on the left To add a new rate structure click the Add New Rate Structure icon Add Rate Structure Please choose the type of rate structure to add Rate Structure Type Seasonal Schedule i Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 8 4 Step 4 Configure the E Billing EXT M Application Settings 3 Select Seasonal Schedule or Flat Rate from the pull down menu and click OK e Select Seasonal Schedule to set up a rate structure with different rates for different times of the day week and or year Then continue with step 4 e Select Flat Rate to set up a rate structure with a single rate only no On Peak Off Peak Seasons Weekend Weekday or Holiday rates Then go to step 6 Rate Structure Name Commodity Number of Seasons Two Seasons Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Day Type Su
46. 0 0145324423 69 0 0 7 Main Building Cubicle 5 Shark 200 0145324524 9 0 0 8 Main Building Cubicle 6 Shark 200 0145282931 98 0 l 9 Main Building Cubicle 7 Shark 200 0145324221 35 0 0 Summary of monthly usage for the aggregated meter the building and all individual meters Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 A 2 A Sample Usage Summary Report EIG Engineering August 2014 Usage Summary Report Highest Usage Meter Comparison Customer EIG Engineering Commodity kWh Highest Usage Meter Main Building 1800ShamesDr 17345 Lowest Usage Meter Main Building Cubicle 5 9 Top Usage Meters Total Usage by Meters Total kWh Usage 0 2000 4000 6000 8000 10000 12000 14000 16000 18000 Main Building 1800ShamesDr Main Building Cubicle 6 Main Building Cubicle 1 Main Building Cubicle 4 Meters Main Building Cubicle 3 Main Building Cubicle 2 Main Building Cubicle 7 Main Building Cubicle 5 I e D uU er c uU O e oO eo O 3 UO O uU O O er gt D Oo E o gt e O gt Q D O eo 3 D er D i Electro Industries Gauge Tech Docs E167701 A 3 The Leader In Power Monitoring and Smart Grid Solutions A Sample Usage Summary Report A 4 c c c c a s v Q o q M q q S E E E E B 2 UO a E o c E N No A v E e e 5 r
47. 00 AM 3 9 2014 5 15 AM 3 9 2014 5 30 AM 3 9 2014 5 45 AM 3 9 2014 6 00 AM go Bill Data for 15 C College Park Apartments Shark200T_unit11 kWh co E rim Error Code Error Desc Modified Value Modified Date 36287016 00 36291596 00 36296176 00 36300756 00 36305336 00 36309920 00 36314504 00 36319088 00 E Counter values don t ma 36323676 00 E Counter values don t ma 36328260 00 36332852 00 36337440 00 36342032 00 36346624 00 36351216 00 36355808 00 36360396 00 36364992 00 36369588 00 36374184 00 DI S See Sea Se eS This screen lets you view the values correct any errors in the data and export the data for external use NOTES eThis screen is available from both the EnergyReporter Settings Editor and the EnergyReporter Dashboard Viewer but you can only modify the val ues using the screen from the EnergyReporter Settings Editor To view this screen from the EnergyReporter Dashboard Viewer select the meter whose data you want to view and click Tools gt View Bill Data Only 20 000 points are displayed on the interface at any time If you are trying to view more than that number of points click the Next and Previous but tons to scroll the data eThe preferred method for correcting data errors is described in Section 6 2 Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data e The buttons on the top of the screen and their funct
48. 14 kWh usage per Day 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 2 3 4 5 6 7 8 89 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Comparison to Last Year aligned by weekday BE August 2014 ME August 2013 wo x a4 E o f a4 o a4 n zx Ho 4 O x Ho A m BG c md E BJ E 3 Tt PS E 3 ow B eo 3 u dU x B c 79 3 5 5 vacas 5 5 m a E 2 8 amp 8 5 5 a FE a 8 5 5 a a BS 5 5 o a E a kWh usage per Day cn z ABS ESG AROS CAMAS AAA RAMOS RARAS VAGAS TREE EDER NEI LL Td op oq RS ES DL Lb LL SE EEE d d AR E a A A O BEES RES RENE ES ENT ERE E RARI L RAE or T m 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 3 4 5 6 7 8 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Main Building Comparison the previous month and year EIG Engineering August 2014 Usage Summary Report Main Building 1800ShamesDr Monthly Usage and Temperature Displays a comparison of monthly usage and temperature The highest and lowest temperature for each day over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 2 6 Monthly Usage and Temperature EN Usage Per Day Max Temperature 750 44 Min Temperature e 700 T 650 600 RR NEN vn A NENNEN A c c e KWh us
49. 2000 05 Tiered Rates are charges that vary depending on the amount of usage For each Tier add the upper usage for that Tier and the rate to be applied to that usage Usage over the highest Tier will be automatically computed For example if the first Tier is 1000kWh and the second Tier is 2000kWh usage from OkWh to 1000kWh will be charged to the first Tier usage from 1000kWh to 2000kWh will be charged to the second Tier and usage over 2000kWh will be charged to the overage Tier g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 21 4 Step 4 Configure the E Billing EXT M Application Settings Select which season s to apply the Tiered Rate to give the Tiered Rate a name and enter the Tiers information the highest amount of usage in the Tier entered in the Tier field and the rate for the Tier entered in the Rate field NOTE The Tiered Rate screen s default is Tiers 1 and 2 and an overage Tier unnumbered Click the button to add a Tier and then enter the upper usage amount and rate for the Tier You can click the button to remove a tier For example in the screen above Tier 1 s rate of 0 01 is applied to usage up to 1000 Tier 2 s rate of 0 02 is applied to usage from 1001 2000 and the overage Tier s rate of 0 05 is applied to usage from 2001 up Let s say the commodity is kWh Since the rate is multiplied by the amount of usage to get
50. 28 pixels in size If it is not the image will be scaled by the application which may result in the image not looking the way you want 5 Click Store to save your entries and then click Exit to close the screen The automatic Bill Report and Usage Report email feature lets you generate hundreds of automated bills or energy reports You can configure the system to send out bills to users automatically on a monthly basis This feature provides you with an automated accounting service and eliminates any need for third party billing providers You receive feedback of successful transmission for accounting purposes and can set up a cc address so that you receive a copy of the bill or usage report i Electro Industries GaugeTech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 4 2 Set Up Rate Structures Configure the E Billing EXT Application Settings The next step is creating rate structures that will be applied to billed usage at locations e A rate structure is the way in which costing is calculated in monetary numbers For example if in an American jurisdiction the rates will be set up in US dollars Each utility has a different method of calculating rates for electrical usage For this reason the user can set up the rate structure to mimic what the utility is generally doing You can set up one rate structure for each commodity at a location e Multiple locations can
51. 4 7 30 AM 0 19 5 7 2014 9 15 AM 0 10 4 22 2014 11 15 AM 0 18 5 7 2014 10 15 AM 0 08 4 25 2014 10 45 AM 0 18 7 2014 10 30 AM 0 07 4 23 2014 3 45 PM 0 18 5 7 2014 2 45 PM 0 06 4 22 2014 11 30 AM 0 18 5 8 2014 5 45 AM 0 06 4 25 2014 11 00 AM 0 16 5 8 2014 6 30 AM 0 06 4 23 2014 4 00 PM 0 18 5 8 2014 8 15 AM 0 06 4 22 2014 11 00 AM 0 18 5 8 2014 7 00 AM 0 06 4 29 2014 11 00 AM 0 16 5 712014 3 15PM 0 06 4 22 2014 12 15 PM 0 18 5 8 2014 8 00 AM 0 06 4 29 2014 3 15 PM 0 18 a File c Generate View Bills Location Info All Bills Customers 5 dy Mains 1 OFF To DECI o To o bi Comparison of monthly kWh usage interval data and Temperature for EE Main Building Mains 1 amp Main Building Aggregated Meter September 2014 B MFG Building Vh m Temperature z P o TEN iem TR T r MEM pese d cm ATT HIA D vs ue MP200 IP95 Month Bima EE eee E CU nh Oe A APP Ul PT kh by interval E db Test Meters lt Nav De s MP2xx Nexus125x Nexus127x COMPARE Nexus15xx Meter Qlayualyes Hag ainjesadway Sep 2014 i Electro Industries Gauge Tech Docs E167701 5 12 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer Usage Versus Weather Pressure for One Week p a6 EnergyReporter EXT Dashboard Viewer rm File Reports Tools Help c Generate View Bills ocatio
52. All Customers E DE i Generate All Bills for Customer Generate All Bills for Location e Click Generate All Bills for Customer to generate all available bills for all locations for the selected customer the customer currently displayed on the screen e Click Generate All Bills for Location to generate all available bills for the selected location the location currently displayed on the screen You will see the Bills to Generate screen shown on the previous page The instructions are the same as those shown in the Generate All Bills section on the previous page steps 4 and 5 The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 5 25 5 Step 5 E Billing Dashboard Viewer NOTE The Generate All Bills for All Customers option is the same as the Generate All Bills option on the previous page Electro Industries Gauge Tech Doc E167701 5 26 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 4 3 View Bills You can view generated bills either by clicking the View Bills icon in the EnergyRe porter Dashboard Viewer s main screen or by clicking Reports View Bills from the screen s Menu bar NOTE The viewed bill is just a temporary file that has been downloaded from the EnergyReporter EXT Database server where the bills are stored Any changes you make to it are not saved on the Database server l The l
53. EETER i 1 5 L 1 i P A 65 ER BER ERTR RR WEIN EEE B MNNN NEN Fri 1 Fri 8 ri 15 Fri 22 Mon 1 Aug 2014 Meter 1 Monthly Usage compared to temperature After this the same graphs are shown for the remaining meters Glossary pg data For Windows XP For Windows 7 pg exe EnergyReporter Settings Editor Bill Structure EnergyReporter Dashboard Viewer Billing Database Channel Charge Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Glossary The data directory for the PostGreSgl database cluster for the EnergyReporter EXT application This is the Common Application Data Electro ndustries Server PostGreSql 8 4 Data directory This is typically C Documents and Settings All Users ApplicationData Electrol ndustries Server PostGreSql 8 4 Data This is typically C ProgramData Electrol ndus tries Server PostGreSql 8 4 Data The directory which contains the PostGreSql Data base Server executable This is typically lt Program Files gt Electro IndustriesiServer Post GreSQL 8 4 The EnergyReporter Ext software for administer ing the Billing Package including location configu ration data import rate configuration and modi fying data values Another name for Rate Structure The EnergyReporter Ext software for generating bills viewing bills and trending the data values The internal storage on the datab
54. IN OO Comparison of monthly kWh usage interval data for 1 Building 1 May 2014 EE Building 1 b CED Office JK compared to Office RM Bs Building 2 Office Ji Office RM OPTIONS Custom lt Nav BP kh by interval i OT COMPARE Meter 2 May 2014 Two Meter Usage Cost Comparison for One Week ae EnergyReporter EXT Dashboard Viewer LOS File Reports Tools Help e ji Generate View Bills Location Info Settings Editor All Bills Customers a Usage Dashboard amp Locations Comparison of weekly kWh cost data for 1 Building 1 4 27 2014 fy Building 1 Office JK compared to Office RM EN ono EO OffcerRm B Building 2 Usage Cost Top Demand Usage vs Temp Usage vs temp kwh cost per day ce e th S Em TERRE OPTIONS 0 40 O Day O Week Month Year Custom to Cn lt lt Nav DP e ho e 27 Sun 28 Mon 29 Tue 30 Wed Apr i Electro Industries Gauge Tech Docs E167701 5 11 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer Breakout of Top Demand Comparison for Two Meters for the Year m Dil Comparison of yearly kWh top demand for Sample Customer 1800 Shames Dr Office JK compared to Office RM Office JK Office RM Date kW demand Date kw demand 5 7 2014 10 00 AM 0 11 4 11 2014 7 45 AM 0 32 5 7 2014 9 45 AM 0 11 4 24 2014 7 15 AM 0 30 7 2014 9 30 AM 0 10 4 28 201
55. Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 3 Click the Apply icon to save your changes The message Values Saved displays in the bottom left of the screen and two new icons appear on the screen Add Location to This Customer and Remove This Customer shown on the previous screen NOTE If you want to delete the customer click the Remove This Customer icon You will see a confirmation window click Yes to delete the customer click No to keep the customer Removing the customer will delete all locations and meters for the customer 4 After clicking Apply you will also see a Configure button next to Report Email settings Click the button to display the Report Email Settings screen o Ih Es Customer Report Email Settings An automated email can be sent a customer when each new report is generated You may define the subject and body for the email for each report type here You must select enable for each report type to send the email Choose default to use the report email settings defined by the provider Use Default Enable Usage Report Usage Report e When this screen first opens the Use default box is checked and the Subject and Body fields aren t editable Keep that setting as is if you want to use the report email settings you already set up in the Default Report Email Settings screen see page 4 6 for this customer
56. Payment To Untranslated Modified Translated M Translation outdated 5 Use the screen shown above to enter the translations You enter the translation in the Translation column for each term in the Phrase column See the example screen on the next page Electro Industries Gauge Tech Doc E167701 7 17 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions File Tools Help Language French Product Common Phrase Count 1615 Untranslated Phrase Count 1615 Outdated Translation Count 0 Last Update 10 8 2014 5 03 25 PM Phrase Translation Remit Payment To Paiement mission 0 resources loaded 0 ressources charg es Configure Group Scripts Configurer les scipts de groupe Configure Meter Configurer metre Untranslated Modified Translated J Translation outdated 6 When you have finished entering the translations click Save Changes to save the language file Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 The Language screen is redisplayed Select the language you want to use from the pull down menu and click OK You will see the following confirmation window Select the Language to be used tings Change Language Warning Changing the language requires restar
57. Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings 4 1 Set Up a Provider First set up the provider information The provider is the person who is sending the bill to the customer The provider will get paid for providing the electricity or other commodity to the customer the customer is the user of the commodity 1 From the EnergyReporter Settings Editor main screen click the Configure Provider Information icon Provider Configuration Provider Name CGIF Provider Telephone 1556 356 0876 Address 5500 25th Street Marcus Hook PA 19061 Payment Address 5500 25th Street Remit Payment To Westbury NY 11590 Marcus Hook PA 19061 Email Server Settings Report Settings Configure Provider Logo 2 For the provider enter Name e Telephone Address e The address where payment should be sent Email Server Settings i Electro Industries Gauge Tech Docs E167701 4 4 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings e Click Configure next to Email Server Settings to open the screen below Provider Email Server Settings Email Settings From accountsrec bbh com 4 Send copy of emails to provider Host Settings mail bbh com 25 accountsrec bbh com Password Send Settings Retries Retry Timeout ms Set to 0 to disable The settings on t
58. Retrieve Logs for this Group 2 Click Frequency Every 12 Hours Configure to open the Interval setting screen 4 Click Apply 3 This screen is the same as shown on page 2 4 see instructions there i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT 2 3 Log Retrieval through MeterManager EXT When log retrieval is performed by the MeterManager EXT application logs for all of the meters in the group s are automatically retrieved at the programmed interval making the job of managing multiple meters simple The EnergyReporter EXT applica tion automatically imports the retrieved logs and uses them to build the EnergyRe porter usage database The usage database is then used to generate usage reports bills and viewing Dashboard data See the diagram below Meters on the Network eS o Auto Connect using MeterManager EXT s Auto Scan Auto Scan Puts Meters in Groups by Type Each Meter Can Once Meters are EnergyReporter Auto Scan Automatically Downloads All Detected Meters be Mapped into EnergyReporter EXT i e assigned to locations Mapped EnergyReporter EXT Configures Meters into the Application EXT Software Automatically Provides Reporting For more detailed instructions on the MeterManager EXT application see Chapter 18 of the Communicator EXT 4 0 Software User Ma
59. Step 4 Configure the E Billing EXT M Application Settings Add a Meter 8 Click the Add a Meter to this Location icon Edit Meter Information Meter Name Meter Serial Meter Type Import Location Select Import Settings to automatically import the meter s settings from a CommExt log database 3 CI ic k to display Meter List Press apply to save changes Channel Commodity Rollover cP Apply FE Km Import settings from Meter log file N E 9 Click the Meter List button to display the meters that have been added through the MeterManager EXT application explained in Chapter 2 Meter Name Meter Type Online Status Next Action Shark 200 Off Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 Shark 200 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM ti Substation 3 Shark 200 Shark 200 Nexus 1272 Nexus 1252 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM 4 29 2014 12 00 PM The Meter List lets you quickly and easily add meters and all of their associated i Electro Industries Gauge Tech Docs E167701 4 43 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings data into the EnergyReporter EXT application NOTE You can add a meter manually if you need to though the preferred method is
60. The Use Default Report Name checkbox is already selected The default report name is the customer number commodity and date of the usage e g 11567 kWh 2013 03 for a report of kWh usage data for March 2013 for customer number 11567 If you want to use a different name for the usage report un check the box and enter a name in the blank field next to it e File format your format choices are PDF Adobe PDF document RTF rich text format or HTML for viewing over the web Report Commodity select the commodity you want to use from the pull down menu Usage reports are only generated for a single commodity at a time Click Single Page Summary if you want to have the month week and day usages on the same page i Electro Industries Gauge Tech Docs E167701 5 17 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer f you select Single Page Summary you can also select Overlay Interval Data Click this option if you want to have trend data or Demand data if you select the display Demand option on the same graph as the usage bars You can select to colorize either TOU or periods Display Demand labels the Interval usage report as Demand 6 Click OK The screen closes and you see the previous screen Click Generate to pro cess the report You see a progress message while the report is being generated When the process is complete you see the following message window
61. Weekend Saturday D Weekday O Weekend Holidays A holiday is a day that is billed at a different rate than a weekday or a weekend Typically it is considered an off peak time which will be billed at a lower rate The EnergyReporter EXT application configures holidays based on a perpetual calendar A perpetual calendar allows you to set up the holidays once and from then on have the software determine all the future holidays based on the rules you set up The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 4 13 4 Step 4 Configure the E Billing EXT M Application Settings You can set up different Holiday rates for different seasons Click the Holidays tab Rate Structure Name Commodity Number of Seasons Two Seasons Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar 5 Add new Holiday January 1st 1st of January 1 1 2013 Easter Easter 3 31 2013 Memorial Day Last Monday of May 5 27 2013 44 Edit selected Holiday July 4th 4th of July 7 4 2013 Labor Day First Monday of September 9 2 2013 LP Sp selected Veterans Day 11th of November 11 11 2013 Thanksgiving Fourth Thursday of November 11 28 2013 Christmas 25th of December 12 25 2013 Use this screen to designate days that will use the Holiday rate Once you set up the holidays you use the Rates tab to enter t
62. a ee ee Fri 1 Fri Aug 2014 m on mn h3 ha Mon 1 Aggregated Meter Monthly usage compared to temperature Iz O o p a 5 on o D un o A 73 En lt EIG Engineering 1800ShamesDr Main Building Total Usage during Month 08 01 2014 to 08 31 2014 Figure 2 1 17345 14 56 Total Usage Peak Usage Peak Demand e e e e e ea er e E i e ww e i e A 6 ua A3 4 4 3 Aeg Jad afesn uA Fri 22 Fri 15 Fri 8 aBesn UA JO pua aynulw S Man 1 Fri 22 Fri 8 Main Building Total usage during month 1800ShamesDr 3838 Total Usage during Peak Week 08 10 2014 to 08 16 2014 p o o p 3 g 3 o o 50 S un gt D e d S 50 S lt Main Building EIG Engineering Figure 2 2 14 Total Usage Peak Usage Aug 2014 Sat 16 Fri 15 Thu 14 Wed 13 Tue 12 Mon 11 sun 10 Main Building Total usage during Peak week p e o p 2 3 o En S un I lt A um un S Bp z lt EIG Engineering 1800ShamesDr Total Usage during Peak Day Monday August 11 2014 Main Building Figure 2 3 741 14 Total Usage Peak Usage L 1 D D L1 D 1 DL L 1 4 Ld eee 21 00 pe es es eee SS l Ll 1 a es eee c Li ico nd c L LL L LL ee ee 00 L L co SS
63. a as opposed to the Communicator EXT 4 0 application log data such as an HMI EXT application database file there are some unique considerations Below is an example of an HMI EXT application database file formatted for use with the Ener gyReporter EXT application HIME KWHR CONDENSATE 1 1 2012 0 00 A 133 6 25538607 1 1 201 0 15 A 138 25538607 1 1 2012 0 30 A 142 5 25538606 1 1 2012 0 45 A 146 5 255386506 1 1 201 1 00 A 151 4 25538605 1 1 2012 1 15 AIV 155 25538605 he database file must have four fields DATE the date of the record formatted as yyyy mm dd TIME the time of day of the record formatted as hh mm ss e KWHR the Energy usage in kilo watt hours e CONDENSATE this field is a pulse accumulator channel intended for con densate steam pulses You can assign this channel to other commodi ties such as gas or water in the EnergyReporter EXT application see Section 4 4 for instructions This field is assumed to be in kilo scale These are the only fields you can use If you need to use more fields split the data into multiple files and import as multiple meters The optimal interval for the data is 15 minutes time stamped on the minute The database file must be a dBase IV format database It can be opened in Excel but should not be saved in Excel as this can cause database corruption which will prevent the file from working with the EnergyReporter EXT application The fi
64. a From Meters EnergyReporter Bill Settings Editor Import Billing Data from All Customers All Locations All Meters at Each Location or All Meters at a Location PC EnergyReporter Dashboard Viewer View Imported Meter Data on Dashboard and Use to Generate Bills Usage Reports Trend Data Bills Usage Reports Trending Charts Casparus ol dile dabndos SRcSLEEO usd cut KF d d aub umd nl Figure 5 2 Bill Generation through the EnergyReporter EXT Application Bills and reports are automatically generated every twelve hours for any location for which there is a full months worth of data You can also manually generate bills and reports if you want The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 5 20 5 Step 5 E Billing Dashboard Viewer 5 4 1 Individual Bills Bills can be generated individually for a specific location and bill period l Select the location from the Location Tree on the left of the main screen then select the Bill Period to view by selecting it in the list of Available Bill Data If the bill has already been generated for the period the bill generation date will be shown next to the billing period See the screen shown below NOTE It may take a while for the data to be displayed if there are multiple meters at the location or if there is a lot of data to search Please be patient 5 a6 EnergyReporter EXT Dashboard
65. a bill is generated Each location may have its own set of meters and rate structures A data monitoring unit which acts as an import point for collecting usage data Each meter may have multiple channels but only one channel can be assigned to a commodity at a time When multiple meters are at a single location the matching usage values are aggregated when generating the bill Dock E167701 GL 2 Glossary Provider The person or organization which is providing the energy sending the bill and receiving payments Rate The monetary value applied to the usage which occurs during specific periods Rate Structure The collection of settings which determine what rates to apply to the usage values for a commod ity Includes calendar rates such as on peak and off peak holidays and other charges Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions GL 3 This page intentionally left blank Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 Glossary GL 4
66. ademarks of Microsoft Corporation in the United States and or other countries Software version 4 0 Modbus 8 is a registered trademark of Schneider Electric licensed to the Modbus Organization Inc Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions Customer Service and Support Customer support is available 9 00 am to 4 30 pm Eastern Standard Time Monday through Friday Please have the serial number and a detailed problem description available When returning any merchandise to EIG a return materials authorization number is required For customer or technical assistance phone 516 334 0870 or fax 516 338 4741 Disclaimer The information presented in this publication has been carefully checked for reliability however no responsibility is assumed for inaccuracies The information contained in this document is subject to change without notice About Electro Industries GaugeTech Founded in 1975 by engineer and inventor Dr Samuel Kagan Electro Industries GaugeTech EIG changed the face of power monitoring forever with its first break through innovation an affordable easy to use AC power meter More than thirty years since its founding Electro Industries GaugeTech the leader in power monitoring and control continues to revolutionize the industry with the highest quality cutting edge power monitoring and control technology on the market today An ISO 9001 2008
67. age per Day cen e e 3oauuauue 3 Bag aumeJadula I c e I e e co on e x E mE mE VW aft il ee ee ee eee ee eee EEE ERE GS dE INSEL ee RE RE a E Il Il it H Ih Il Ja pepe ALIS EM L w 1 1 d ee uy l V v i E AJ E E IM i m A Fri 22 Mon 1 co mn en Fri 1 Fri Aug 2014 Main Building Monthly usage compared to temperature Figure 3 1 71 0 0 e e Main Building Cubicle 1 Total Usage during Month 08 01 2014 to 08 31 2014 E o o p E z 3 o o 50 S un e d S 50 lt EIG Engineering Total Usage Peak Usage Peak Demand em DESA UAM JO pua ejnulul GL Meter 1 Total usage during month EIG Engineering August 2014 Usage Summary Report Main Building Cubicle 1 Total Usage during Peak Week 08 03 2014 to 08 09 2014 Total Usage 31 Peak Usage 0 Figure 3 2 kWh usage per Day o o o a o o a Cn e Cn o c o 15 minute trend of kWh usage E d CAM ULL T SL ET LL M LRL Icd LL Alto mena ooo ooo o Sun 3 Mon 4 Tue 5 Wed 6 Thu 7 Fri 8 Sat 8 Aug 2014 Meter 1 Total usage during Peak week 15137 JOLIE LINA Is August 2014 Usage Summary Report Main Building Cubicle 1 Total Usage during Peak Day Friday August 08 2014 Total Usage 5 l Peak Usage 0 Figure 3 3 0 080 0 075 0 070 0 065 0 060 15 minute trend of
68. an right click in the box on the right and select Set all rate times to either Off Peak or On Peak You can select multiple time ranges by clicking on the first rate time you want to change then holding down the Shift key and clicking on the last rate time you want to change the rate times you selected are now high lighted in blue Then right click in the box on the right and select Set selected rate times to either Off Peak or On Peak The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 4 26 4 Step 4 Configure the E Billing EXT M Application Settings Seasons Tab Click the Seasons tab to set up the dates for between two and four seasons The dates for the seasons determine what rate is charged for usage in that time period The rates are set up in the Rate Times tab which was just explained So for example if you set up two seasons and you set a Weekday On Peak rate for Season 1 and a different Weekday On Peak rate for Season 2 the program checks the date of usage to see which rate should be applied NOTE You will only see the Seasons tab if you selected more than one season Rate Structure Name Commodity Number of Seasons Four Seasons Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Season Names Season Transition Dates Season One Season One March 21 Season Two Season Two June M Season Three Season
69. anager EXT to Automate EnergyReporter EXT When you click Connect the software looks for the meter and when found shows the screen below Tools Help e o Meter List Configure Meter Configure Scripts Script Status Auto Scan Enter New Meter Connection caret sates Manual Connect Settings Test Connection Results Connection Type Meter Name Shark200_Unit9 IP Address 172 20 167 103 Serial Number 0020061918 Port 52 Meter Type E149 Run Protocol Modbus TCP T E fw run 0029 Modbus Address 1 2 g fw boot 0002 map 52 Connection Options New Device Connection mn 172 20 167 103 Assignto Group s View Meter In CommExt This screen shows meter connection information Click Connect to add the meter to the Meter List E Electro Industries haugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT You set the interval for log retrieval for a manually connected meter by clicking Configure Scripts from either the left side or top of the Meter List screen MeterManagerMonitor OOOO Tools Help l Select the group the meter is in RB Meter List Configure Meter Configure Scripts Script Status Auto Scan Configure Group Scripts 5 Click Save Select Group MP200 0 0 0 0 0 0 0 00 0 Y v to implement change Meter Name Meter Type Online Status Security Retrieve Logs Online Not Enabled F
70. ant to change the interval click the Configure button and then enter the new interval See the example screen on the next page i Electro Industries Gauge Tech Doc E167701 2 3 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT Changing Log Retrieval Interval screen Automatic Scan Configuration Set IP range to scan 172 20 160 0 gt 172 20 167 255 Disable Automatic Log Automatic Log Retrieval should only be enabled on one Retrieval computer on a network If this is the server or only computer enable this Otherwise this should be left disabled Set Log Retrieval Schedule Click Configure to Every 12 Hours Configure i open this screen 4 Automatically assign newly found meters to groups based on meter type Click to select Interval to set up Click to set interval Click Apply to interval log retrieval Time to seta for log retrieval save the new specific log retrieval time or interval Manual to perform a manual log retrieval e g to test the system Click Save to begin the automatic scan for meters with these settings In the Searching IP Address field of the Status section the Meter List screen will show the IP addresses as the application searches for meters When searching is complete the discovered meters will be shown in the Meters List see the example screen on the next page Electro Industries Gauge Tech
71. ase cluster which holds all the data imported from the meters A single type of data item such as kWh or pulses A monetary value applied to the bill outside of the normal usage This includes things such as a peak demand charge credits and taxes Doc E167701 GL 1 Commodity Customer Database Cluster Database Server EnergyReporter Ext Import Location Location Meter Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Glossary A type of channel typically from Energy or accumulations which is a usage value the Software uses when computing the rates for a bill The person or organization which is receiving the bill A customer may have multiple locations each of which gets its own bill The collection of databases which the Database Server provides access to A database server may provide access to multiple database clusters The combination of computer and process that provides the interface to the database cluster currently PostGreSqgl 8 4 The package of software which includes EnergyReporter Settings Editor EnergyReporter Dashboard Viewer and the Database Server The actual source of the data imported for the meter This is typically a log file such as an HMI Ext dbf file or a Communicator Ext db log file This file is scanned when imported and new data is placed into the billing database A single unit for which
72. box to export analysis information such as error code or modified date along with the regular data If you leave this box unchecked only the Timestamp and Value are exported 5 File Options you will see this field if you choose the csv file Output option Click Browse to locate the directory for your file and enter a filename i Electro Industries Gauge Tech Docs E167701 6 6 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data 6 Click Export to export the data You will see a Confirmation window when the export is complete Click OK to close the window and the Data Export Options Screen From the Tools Export Meters Data for either the EnergyReporter Settings Editor or the EnergyReporter Dashboard Viewer 1 Click Tools Export Meters Data Customer 15 C Location College Park Apartments Commodity 7 Export Cost amp Bill Period 5 1 2014 to 6 1 2014 Custom Range Available Data Range 1 5 2014 to 5 14 2014 Start Date Thursday May 01 2014 End Date Sunday June 01 2014 2 The currently selected customer and location are displayed in the screen e Select Commodity from the pull down menu Click the Export Cost checkbox if you want cost data exported Either click Bill Period and select a period from the pull down menu or click Custom Range and select the Start and End Date from the pull down menus 3 Click Export A window opens letting you select the location of
73. cense limitations restrictions and other terms in this Agreement If You violate any of these limitations restrictions or other terms the license grant will automatically and immediately terminate The license descriptions in this Section 1 Grant of License define the scope of rights that EIG grants to You Any usage of the SOFT WARE and or User Documentation outside the scope of the applicable license grant or otherwise not in accordance with this Agreement constitutes an infringement of EI G s intellectual property rights as well as a material breach of this Agreement b Backup Copies You may make one copy of the SOFTWARE solely for backup pur poses c Network Use You may also install a copy of the SOFTWARE on a central storage device such as a network server from which other computers may use it however You must acquire and dedicate a license for each copy i e session or instance of the SOFTWARE running at any one time A license for the SOFTWARE may not be shared or used concurrently on different computers d Prohibited Use EIG does not permit the following use and You acknowledge that such use and or actions shall be prohibited i Use You may not and may not permit any third party to install access or other wise copy or use the SOFTWARE except as expressly authorized by this Agreement ii Reverse Engineering You may not and may not permit any third party to reverse engineer decompile or disasse
74. cept for the Paths settings See the screens below p E P f Paths Configuration ul Language Paths Configuration ul Language PgTools Path C Program Files x86 Electro Industries E Billing Ext BillSetting Browse Default Bill Definition C Users Public Documents Electro Industries E Billing Ext Re Browse Default Archive Path Browse Plugin Directory C Program Files x86 Electro Industries E Billing Ext BillView Browse OK Cancel OK Cancel EnergyReporter Settings Editor Options Screen EnergyReporter Dashboard Viewer Options Screen 7 4 1 Path Setting EnergyReporter Dashboard Viewer setting e Default Bill Definition this is the template for the bills Click Browse to set up another location EnergyReporter Settings Editor settings e Pg Tools Path this is the path to the pg_tools exe which is a utility used to archive restore and perform other maintenance operations on the database cluster Click Browse to set up another location e Default Archive Path this is the default location where the archive is stored when the database cluster is archived Click Browse to select the location i Electro Industries Gauge Tech Docs E167701 7 12 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 4 2 Configuration Setting The settings are similar for the EnergyReporter Das
75. certified company EIG sets the industry standard for advanced power quality and reporting revenue metering and substation data acquisition and control EIG products can be found on site at mainly all of today s leading manufactur ers industrial giants and utilities El G products are primarily designed manufactured tested and calibrated at our facil ity in Westbury New York Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions License Agreement for the EnergyReporter EXT Software Application This legal document is an Agreement between you as the end user of EnergyReporter EXT software SOFTWARE and Electro Industries GaugeTech EIG EIG licenses this SOFTWARE to You only upon the condition that you accept all of the terms con tained in this Agreement BY SELECTING THE AGREE BUTTON BELOW THIS AGREEMENT OR BY INSTALLING UPLOADING ACCESSING OR OTHERWISE COPYI NG OR USING ALL OR ANY PORTION OF THE SOFTWARE YOU AGREE TO BE LEGALLY BOUND BY THE TERMS OF THIS AGREEMENT IF YOU DO NOT ACCEPT THE TERMS OF THIS AGREEMENT YOU MUST NOT USE THE SOFTWARE If You are proposing to load the SOFTWARE from a disk or other portable media select the DISAGREE button and the loading of the SOFTWARE will be can celed If You are proposing to download the SOFTWARE or a License Key do not do so If You have acquired a physical software pack do not open it Promptly return the unopened soft
76. click Scan to view and address the errors If you do not have any more errors to correct click X to close the window The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 6 10 6 Managing Data 6 3 Re Aggregate All Locations You can force all aggregate meters to reaggregate the data from their locations 1 From the EnergyReporter Settings Editor click Tools Database Maintenance Re aggregate all Locations 2 You will see a progress screen as the re aggregation is taking place 6 4 Rebuild Period Analysis All data ranges are based off the Period Analysis to provide faster access to data You can force each location to rebuild this analysis 1 From the EnergyReporter Settings Editor click Tools Database Mainte nance gt Rebuild Period Analysis 2 You will see a progress screen as the rebuilding takes place Electro Industries Gauge Tech Docs E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data This page intentionally left blank Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 7 Additional Features and Advanced Functions 7 Additional Features and Advanced Functions 7 1 Viewing the Action Log The EnergyReporter EXT application has a log in which actions such as importing generating bills updating data and sending emails are stored
77. ct this option you must enter a Filename in the bottom of the screen e Clipboard exports the data to the clipboard Be careful when using this option as the amount of data being exported may be very large When you select this option you do not enter a filename 3 The setting in the Layout box controls the layout of the data being exported The only option is Tabular which means the data is exported in a table format rows are data entries and columns are fields 4 The settings in the Format box control how the output is formatted e Column Separator use this setting to select the character used to separate fields in a row e Comma is the most common separator Tab should be selected if you plan to paste the data into a spreadsheet program e g the Microsoft Excel amp application e Space should be selected if needed by your application e Line Separator use this setting to configure the sequence of characters used to indicate the end of a row Your options are CRLF and LF Different operating systems and software applications expect different line endings but CRLF is the most common e Include Column Headers click this box to put the name of the field at the top of the column before the start of the data You may want to leave this box unchecked when using automated processing if your application doesn t know to discard the first line the column headings e Include Billing Event Information click this
78. d Rate c Click OK to save the fixed charge 7 Click Store to save your Flat Rate rate structure Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 8 Click Exit to return to the Configure Rate Structures screen Your new rate struc ture is now listed in the Rate Structures box and there is a new box called Locations That Use This Rate at the bottom left of the screen Once you assign customer loca tions to this rate they are listed in the box oU KE Rate Structures Eleci3 Add new Rate Structure Electricity Edit the selected Rate Structure Remove the selected Rate Structure Edit Commodities Locations that use this rate Customer Location NOTES To edit an existing rate structure click on the rate structure and click the Edit the Selected Rate Structure icon You will see the same screen as when you are add ing a rate structure but it will show the rate structure s settings Change what you want and click OK to save the changes Any new bills generated will use the changed settings f you edit a rate structure that has already been used for the generation of a bill you are given the opportunity to archive the rate structure in its pre edited condition so that previously generated bills may be reproduced using the rate structure that was in effect at the time the bill was
79. d or Seasonal Off Peak usage The Peak Demand rate you enter will be applied to peak demand in the selected rate periods when the bill is generated i e the Peak Demand usage is multiplied by the Peak Demand rate to get the Peak Demand charge i Electro Industries Gauge Tech Docs E167701 4 19 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings f Coincidental Peak Demand is a charge applied against the Peak Demand over the period of the bill where the Peak Demand is computed based on the configured Utility meter rather then the meters at the location For example 2 locations with 4 meters total Location 1 has 1 meter which is the Utility meter that the Peak Demand is based on The demand values for this meter are shown in the table below Time E Reading 12 00 15kWh 12 15 17kWh 12 30 l6kWh 12 45 14kWh Location 2 has 3 meters The meters demand values are shown in the table below kWh Reading TT TT in this row This is the time 12 00 7kWh 8kWh 3kWh are added of the Utilit together meter s Pea es 12 15 4kWh 3kWh lkWh a then Demand will have 12 45 15kWh 20kWh 9kWh Fate charge applied to them When the Coincidental Peak Demand fixed charge is set up using the Utility meter and this rate structure is applied to Location 2 a bill generated for Location 2 will have a Coincidental Peak Demand value of 4 3 1 8kWh x the fix
80. der In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings This page intentionally left blank Electro Industries hauge Tech Doc E167701 4 54 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 Step 5 EnergyReporter Dashboard Viewer The EnergyReporter EXT application has two main components The first is a settings editor server that provides all of the calculations and stores the data in the usage database The second is a viewer application The viewer component allows the user to view and analyze the stored data Both components can be installed on one machine however the editor server can only be installed on one machine The viewer is a client component and can be installed on multiple machines Single Computer Mode One Computer Only or Remote Desktop Application Settings Editor Server Viewer Communicator EXT 4 0 MeterManager EXT Multi Computer Mode Server Clients Settings Editor Server Viewer Viewer Communicator EXT 4 0 Communicator EXT 4 0 MeterManager EXT Figure 5 1 Settings Editor Server and Viewer Installed on One PC Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 5 1 5 Step 5 E Billing Dashboard Viewer You used the EnergyReporter Settings Editor Server to set up customers locations for cust
81. e Report is a customized report containing the location and data you specify or for all customer locations containing extensive detailed usage information 5 3 1 Executive Summary Usage Report 1 From the EnergyReporter Dashboard Viewer s Location Information screen click the Executive Summary icon on the right side of the screen a6 EnergyReporter EXT Dashboard Viewer File Reports Tools Help z i i i l k Generate View Bills Usage Dashboard Settings Editor T All Bills Customers E TY Location Information amp Locations J Building 1 Location Specifics B Building 2 Customer ID 1 Location Name Building 1 Address 10 College Park Drive Altoona PA 16601 Next Bill Date 11 1 2014 Rates Electricity Meters 9 Bill Data Range 11 2 2013 10 8 2014 aca casta ae usage Previous Month Views Bill 10 1 2014 Bill Generated 10 9 2014 Usage Report 10 1 2014 v Report not generated 2 You will see the window shown on the next page Use it to select the data you want to see in your report This feature lets you generate a customized report with only i Electro Industries Gauge Tech Docs E167701 5 14 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer the data you want For example you can choose to view the highest usage per meter or the total usage per meter during the Peak Day Executive Summary Usage Rep
82. e Tech The Leader In Power Monitoring and Smart Grid Solutions G Edit Imported Data J Remove Meter J Edit Meter E J Import logs now Click this icon Doc E167701 6 Managing Data Data Search Meter Main CPU Values to show J All Values Data Point All Errors Wednesday October 23 2013 Zero Counters LT ME EMT E 79 9747 Wednesday October 23 2013 Sissi Rollover di Increasing Too Fast Bill Period Wobbly Value Decreasing Counter Good Values 3 This screen lets you choose which data point channel date range and type of values you want to view Meter from the pull down menu select the meter whose data you want to view Only meters at the currently selected location are shown Data Point the channel of the data to view There are typically three values for each commodity a commodity this is the value from the meter s logs These are your base usage values and are the only values you can change as all other values are computed from this value e g kWh If you want to view the raw usage data from the meter select this option b lt commodity gt interpolate interval this is the computed interval value of the commodity typically in 15 minute periods The values are interpolated from the root commodity values to correct for odd timestamps and missing data These values cannot be changed as they are computed from the root commodity e g kWh If you
83. e no errors and haven t been generated before The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 5 24 5 Step 5 E Billing Dashboard Viewer are selected for generating bills their box is checked NOTES e Any period which already has a bill generated for it appears in grey with an unchecked box You can still select it if you want to generate another bill for that period e g if the meter s data was changed after the bill was generated This can happen if you generate a bill before the end of the month e Any period which contains errors or is missing too much data appears in red You cannot generate bills for these periods until you correct the errors see Sec tion 6 1 7 for instructions 5 When you ve selected all the periods you want to generate bills for click Generate While the bill is being generated the progress is displayed The Bills to Generate screen closes once the bills have been generated Generate All Bills for Customers Location Since the Generate All Bills option can take a long time to complete the EnergyRe porter EXT application gives you two additional options for generating a smaller num ber of bills Access these options from the Reports Generate Bills submenu from the EnergyReporter Dashboard Viewer main screen s Menu bar The submenu is shown below View Bills View Usage Reports Generate Bills Generate All Bills for
84. e rate structure click Yes to remove click No to keep the rate structure Removing the rate structure also removes it from any locations using it e You can also add edit or delete commodities from the Rate Structures screen a Click the Edit Commodities icon Configure Rate Structures Rate Structures Add new Rate Structure Click Edit Commodities this icon ag Electro Industries haugeTech Docs E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings b You will see the screen shown below The existing commodities are listed in the box on the left To add a commodity click the Add New Commodity icon to edit a commodity click on the commodity in the list and click the Edit Selected Commodity icon In both cases you will see the same Edit Commodity screen that was explained earlier in this section beginning on page 4 8 a inve a Commodity List LOINA as A Add new Commodity kGallon kWh i Negative electricity Edit selected Commodity special commodity Remove selected Commodity c To delete the commodity click on the commodity in the list and click the Remove Selected Commodity icon You will see a confirmation window click Yes to delete the commodity click No to keep the commodity Remov ing a commodity will remove all of the rate structures that use the commodity
85. e sent to a customer when each new report is generated You may define the subject and body for the email for each report type here You must select enable for each report type to send the email Report Bill Report Subject Bill Report Enable Bill Report Select Bill Report or Usage Report from the pull down menu Click the Enable checkbox to set the report to be emailed automatically Enter a Subject line and Body text that will appear in the email Click OK to save the settings The screen closes NOTE If you want to send both Bill Report and Usage Report repeat this process b In the Report Settings screen you have the option to enter a Due Period If you want to do so click the checkbox next to Display Due Dock E167701 4 6 i Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Period in Bill and enter the number of days from the bill s origination date until the due date c You also have the ability to enter optional text that you want to be printed on the bill If you want to do so click the checkbox next to Enable Bill Notes and enter the text you want printed on the bill in the Notes field d Click OK to save your selections You will be returned to the Provider Information screen Click Select to choose a company logo for the bill NOTE The image must be 256x1
86. ecific rates by Default On Peak Off Peak and Holiday rates If you have set up seasons you can configure rates for each season you can also configure Holiday rates for each season The rates will be applied to the usage when the bill is generated e g if you set a rate for Season l Off Peak that rate is applied to all usage that occurs during Off Peak times during the period designated as Season 1 c ul EE Name SCE TOU 8 B Commodity kVAR Number of Seasons Four Seasons Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Season Charge per unit Add Rate Holiday 0 01391 Mid Peak Season One 0 01391 Off Peak Season One 0 01391 Edit selected Rate Mid Peak Season Two 0 01396 Off Peak Season Two 0 01393 Remove selected Rate On Peak Season Two 0 01396 Holiday Season Three 0 01392 Off Peak Season Three 0 01392 On Peak Season Three 0 01396 Holiday Season Four 0 01394 Off Peak Season Four 0 10394 On Peak Season Four 0 01397 i Electro Industries Gauge Tech Docs E167701 4 23 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings a If you want to use more rates than Off Peak and On Peak click the Add Rate icon Edit Rate Name Surcharge Season Season Two Charge per Unit b Enter a name for the rate sel
87. ect the Season the rate will be applied to if you selected only one season you will only be able to choose Season One enter the charge per unit For Energy usage this is the charge per kWh c Click OK to save the rate and return to the Rates tab screen The rate you added is now listed in the screen Make sure you assign Rate Times for this new rate see below NOTES To edit a rate click on the rate in the list and click the Edit Selected Rate icon You will see the same screen as when you are adding a rate but it will show the rate s settings Change what you want and click OK to save the changes To delete a rate click on the rate in the list and click the Remove Selected Rate icon You will see a Confirmation window asking if you are sure you want to remove the rate click Yes to remove click No to keep the rate If you delete a rate the rate times assigned to it see the following sec tion are reassigned to the next available rate i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Rate Times Click the Rate Times tab to assign periods to your rates You can assign rates to 15 minute time intervals within a day You set rates for both weekday and week end time intervals as well as for both Season 1 and Season 2 if you set up two seasons for this rate structure These settings are used to genera
88. ed charge rate since the Peak Demand at meter 1 Location 1 is at 12 15 NOTE The Utility meter can be at any location i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Charge Type Coincidental Peak Demand Apply To Season Al Seasons Coincidental Peak Demand Name Peak Demand Coincidental Peak Demand 0 03 Rate Coincidental Utility Meter Sample Customer 1800 St v A Coincidental Peak Demand Charge is a charge applied against the Peak Demand over the period of the bill where the Peak Demand is computed on the configured Utility Meter rather then the aggregation of the meters at the location After selecting Coincidental Peak Demand select the season s to apply it to enter a Name and Rate for the Coincidental Peak Demand and then choose the coincidental Utility meter from the pull down menu g Tiered Rate a tiered rate gets higher more expensive as the amount of energy consumed increases This rate type is typically used to encourage customers to conserve usage You would use the Tiered Rate option to set up charges that vary depending on the amount of usage during the Bill period charging higher rates when their usage exceeds a certain amount Charge Type Apply To Season All Seasons Tiered Rate Name Tiered Rate 1000 01 2000 02 Over
89. ep 5 E Billing Dashboard Viewer 3 Information about the location is shown on the right side of the screen go EnergyReporter EXT Dashboard Viewer Bol x File Reports Tools Help Generate View Bills Usage Dashboard Settings Editor 5 A All Bills Customers TT Location Information amp Locations 5 Building 1 Location Specifics B Building 2 Building 1 ES Monthly Utility Bill 10 College Park Drive Be View your monthly Utility bil Altoona PA 16601 Next Bill Date 11 1 2014 Executive Summary Rates Electricity Mice den Meters 9 U Dashboard Bill Data Range 11 2 2013 10 8 2014 V OEE sata IATER usage Previous Month Views Bill and Report Bill 10 1 2014 v Bill Generated 10 9 2014 Status Usage Report 10 1 2014 Jara Report not generated 4 P Click to select another month date 4 You can select a different month date to see the Bill and Usage Report status for that month The icons on the right of the screen let you e Monthly Utility Bill view the bill for the month If it hasn t been generated yet it will be generated and then displayed See Section 5 4 e Executive Summary generate the Executive Summary Usage report based on your selections See Section 5 3 1 Usage Dashboard display the Usage Dashboard see Section 5 2 The icons at the top of the screen let you Generate All Bills generate customer bills See Section 5 4 View Bills see already genera
90. er Data Weather data is available for this location Station Location Lakemont US Station Latitude 40 52 Station Longitude 78 39 Current readings Rate Structure Temperature 7 00 Farenheit Humidity 93 00 Pressure 1019 00 mb Would you like to enable automatic weather updates for this location Meters Values Changed NOTES e The default for weather display is Fahrenheit You can change it to Celsius through the Options screen s Configuration tab See Section 7 4 2 for instruc tions You can disable the automatic configuration of weather data through the Option screen s Configuration tab See Section 7 4 2 i Electro Industries Gauge Tech Docs E167701 4 39 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings e Weather data consists of temperature humidity and barometric pressure Usually the weather station updates this information not more than once an hour but it may choose to limit the number of requests that can be fulfilled per hour 7 The screen changes to offer more options Edit Location Information Location Name 1800 Shames Dr Bill Period Ath of the month Location Address 1800 Shames Dr Westbury NY 11590 Weather Data Settings Enabled Weather Open Weather Map Latitude 40 75566 Longitude 73 58763 Rate Structure Add a Meter to this Location Add Rate Structure Of
91. er In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 7 2 7 Additional Features and Advanced Functions e Select between Show All Actions and Select Unacknowledged Action Errors from the pull down menu Clear all actions by clicking the red X You will see a Confirmation message win dow Clear any selected action highlighted action by clicking the red exclamation point You will see a Confirmation message window 6 If there is an error associated with an action you can correct the error and then perform the action again from the Action Log Viewer screen For example if there is an error in importing you can correct it and then click on the original action and select Re import Data 7 2 Database Maintenance The EnergyReporter Settings Editor gives you options for maintaining the EnergyRe porter EXT database To access these options 1 From the EnergyReporter Settings Editor click Tools Database Maintenance Main tenance Utilities from the main screen s Menu bar You will see the screen shown below displaying a warning message ccr M Database List Archive Databases Restore Databases Clear Databases Db Actions 271252167 BST Server 127 0 0 1 Database settings User ID b 32854180 Open Server 127 0 0 1 Database action history Use 33476626 Closed Server 127 0 0 1 Database securnty User ID b 35915408 Closed Warning Many of the tools on the
92. ergyReporter EXT Whether or not meters are grouped by meter model Leave the checkbox selected to group any discovered meters this way for example into Shark or Nexus groups Groups are used to perform tasks on multiple meters at one time See Section 18 2 2 for information on groups Disable automatic log retrieval the default of this screen is that automatic log retrieval is disabled for the computer the box is checked That is because only one computer in the network the server should be enabled for automatic log retrieval e f this computer is not the Log Collection server leave the box checked e f this computer is the Log Collection server click on the box to uncheck it the screen will change as shown below Automatic Scan Configuration Set IP range to scan 172 20 160 0 gt 172 20 167 255 Disable Automatic Log Automatic Log Retrieval should only be enabled on one Retrieval computer on a network If this is the server or only computer enable this Otherwise this should be left ame Click to set up a Set Log Retrieval Schedule log retrieval Every 12 Hours interval of other than every 12 Automatically assign newly found meters to groups based on meter type hours not recommended Save Cancel Now that you have enabled automatic log retrieval for the computer you can set the log retrieval interval The default is every 12 hours which is the recommended setting If you w
93. fice DS Edit Rate Structure Office JK Office RM Remove Rate Structure Office RP Shark200 Unit9 ChaeLINNT cmd Remove this Location soe J E The new options let you e Configure weather data collection manually Add a meter to this location Add a rate structure to this location Edit a rate structure for this location Remove a rate structure from this location e Remove this location In addition there are two boxes on the screen one for Rate Structures assigned to this location and one for meters assigned to this location When you are adding a i Electro Industries Gauge Tech Docs E167701 4 40 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings new location these boxes will be empty but if you are editing an existing location there will be entries in the boxes Enable Weather Data Collection Manually If you want to manually enter or edit weather data collection settings for a location a Click the Configure button in the Weather Data section of the screen Lh S ss Click the Enable Location Weather Data Settings checkbox 7 Enable weather data collection Search Click the The city state and Address Altoona PA 16601 Search Search button zip code of your location are displayed here Station Location Latitude 0 Longitude 0 b Make sure the Enable Weather Data Collect
94. g and Smart Grid Solutions 1 Step 1 Install the Application 1 3 Connect to the Database Server If you are running the EnergyReporter EXT application on a PC that is not the data base server or does not have the database files you want to use you need to specify where the application can find the database files you need 1 3 1 Specify the Database Server When you open the EnergyReporter EXT application s EnergyReporter Settings Editor the application tries to connect to the database on the PC you are using If the data base is not found for instance if you have set up the Network database sever see Section 1 2 1 step 6 and you are on a Client PC which is a PC other than the Net work server you will see a screen with the Configure System icon Click the icon to open the screen shown below NOTE If you set up the Local Only database server see Section 1 2 1 step 5 on the PC you are using you do not need to change anything unless you want to use a bill ing database that is stored on another PC If that is the case click File Connect to Database from the EnergyReporter Settings Editor Menu bar and continue with the instructions below Select database to connect to MR T Database Type PostGre Database Database Settings Data Source 127 0 0 1 Local Only Database Port 5432 v Default 4 Requires Login Username billing Password 1 Enter the information for the database server the
95. g instructions for external databases such as an HMI EXT application database 15 Select the commodity from the pull down menu Once the data has been imported it will be tracked by the commodity You can select only one channel per commodity per meter e g Total Watt hours for kWh A meter can have multiple commodities See the diagram below Tracking Energy Usage through Voltage and Current Inputs Pulse Input 1 Gas Usage Pulse Input 2 Condensate Figure 4 3 Example of Meter Measuring Multiple Commodities 16 Auto adjust Rollover is the default selection on the screen The unscaled rollover field will display the settings from the Communicator EXT M 4 0 software for this channel if you click on the Auto adjust Rollover box to de select it You can edit the value in the unscaled rollover field NOTE Manually setting the rollover field is only applicable to older Nexus 1250 models or HMI EXT application values 17 The Percentage of Usage Applied to Bill field lets you add or subtract a portion of the usage for this channel for this meter to the bill when it is generated allowing for credits for certain meters You might want to use this if you want to remove a meter from being billed for this usage For example if you have a main meter at a location e g a meter attached to the building s utility feeder and submeters in individual tenant units you may want to bill for main meter usage comprised of
96. ge CTC Flat Rate 0 00505 e DA CRS DWR bond Flat Rate 0 00505 i Edit selected Fixed Noble Americas Flat Rate 0 067375 Charge Noble Regents Admin Flat Rate 0 00075 PCIA Flat Rate 0 01423 MEM eem ER 3e Charge Peak Demand Peak Demand 11 84 You can add a fixed charge edit an existing fixed charge or remove an existing fixed charge You can also assign the fixed charges to any of the seasons you have set up i Electro Industries Gauge Tech Docs E167701 4 16 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings a Click the Add Fixed Charge icon You will see the screen shown below r Charge Type Flat Rate Apply To Season All Seasons Flat Rate Name DA CRS DWR bond Flat Rate 0 00505 A Flat Rate is a charge which applies to the total usage such as a Generation Charge or a Fuel Surcharge The rate is multiplied by the total usage for the commodity b Select the Charge Type from the pull down menu You can select Fixed Peak Demand Flat Rate Tax Coincidental Peak Demand or Tiered Rate e Fixed select this to add a single charge that is added to the bill when it is generated regardless of the usage amount e g processing fee e Peak Demand select this to enter a Peak Demand surcharge which is an additional charge applied to Peak highest amount demand during the billing
97. hboard Viewer and the EnergyRe porter Settings Editor This setting controls what options are available to the user l Click the Configuration tab You will see the screen shown below from the Ener gyReporter Settings Editor The Options screen from the EnergyReporter Dashboard Viewer does not have the Autoconfigure Weather Data checkbox Configuration UI Language Configuration Type Basic Advanced Weather Data Temperature Units Celsius Autoconfigure Weather Data 2 Click the radio button of the option you want to set e Basic restricts access to functional billing tasks and provides a user friendly interface to configure settings Advanced provides access to all options and should only be chosen for advanced users 3 The Weather Data section lets you select Celsius or Fahrenheit from the pull down menu 4 The default Weather Data configuration is Auto Configure If you do not wish to automatically configure settings for weather data acquisition for new locations at the time they are first created click on the Autoconfigure Weather Data button to disable this feature Electro Industries hauge Tech Doc E167701 Ja 19 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 5 f you ve made a change when you click OK you will see this window Settings have changed which require the software to restart to use Would you like to restar
98. he Holiday rate a Click the Add New Holiday icon Edit Holid Holiday Name o Every January 1 Nearest Monday Nearest Weekday D The First Sunday January D Specific Day Thursday October 03 2013 D Special Days Easter b Enter a name for the holiday i Electro Industries Gauge Tech Docs E167701 4 14 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings c You have these options for setting up the holiday Click the radio button next to Every and select the month and day from the pull down menus e g January 1 The nearest Monday and Nearest Weekday checkboxes are used for holidays that are changed to another day of observance if they fall on a Saturday or Sunday If the holiday will be celebrated on the following Monday if it falls on a weekend click the Nearest Monday checkbox If the holiday will be celebrated on the nearest weekday if it falls on the weekend i e Friday if the holiday falls on Sat urday or Monday if it falls on Sunday click the Nearest Weekday check box Click the second radio button and select First Second Third Fourth Fifth or Last from the first pull down menu select the day of the week from the second pull down menu and select the month from the third pull down menu e g The Third Thursday in November for U S Thanks giving Day e Click the radio button next to Spec
99. highest and lowest usage for each hour and weekday over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 1 4 Average Hourly Usage Min Usage GE Average Usage Max Usage Average KWh hourly Usage in2dB 2932 08 m SSE Bee REE oa 12 00 AM 3 00 AM 6 00 AM 3 00 AM 12 00 PM 3 00 PM 6 00 PM 9 00 PM Average Weekday Usage GE Average Usage Max Usage Min Usage 193 609 08 27 2014 15 00 00 Q Average KWh weekday Usage sunday Monday Tuesday Wednesday Thursday Friday saturday EIG Engineering August 2014 Usage Summary Report Main Building Aggregated Meter Comparison to previous Month and Year Displays a comparison of daily usage between this month and last month and this month this year and this month last year The daily usage is lined up by week day for each month The numbers at the bottom indicate what day in the month each bar represents The top value is the current month the bottom value the month being compared against Figure 1 5 Comparison to Last Month aligned by weekday EEUU August 2014 NN July 2014 kWh usage per Day adn y Epi 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Comparison to Last Year aligned by weekday BENE August 2014 BN August 2013 wo zx a4 A o x a4 o a4 o zx a4 o zx oH 4 n am
100. his screen are used by the software to automatically email bills and enabled reports to customers Enter the following From Email enter the name that will appear in the emails From field NOTE When the checkbox next to Send copy of emails to provider is selected checked a copy of any bill or report email sent to a customer is sent to the From email address Host Settings enter the email s Host Name Port and User name and Password if being used Send Settings enter the number of email retries in sending and the Retry Timeout in milliseconds the default is 1000ms If you want to disable the Retry Timeout enter O in this field Click OK to close this screen You will see the Provider Information screen i Electro Industries Gauge Tech Docs E167701 4 5 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Report Settings e Click Configure next to Report Settings to open the screen below Report Settings Email Report Settings step a Bill Report Settings 7 Display Due Period in Bill f step b Due Period 14 Days 7 Enable Bill Notes step C Notes Thank you for your prompt payment step d i OK Exit a Click Configure next to Email Report Settings to set up automatic emailing of bills and or usage reports The screen below opens Default Report Email Settings An automated email can b
101. icense You hold Updated versions of the SOFTWARE will be subject to the terms and conditions of this Agreement and refer ence to the SOFTWARE in this Agreement means and includes any version update 8 ALL RIGHTS RESERVED EIG retains title to and ownership of the SOFTWARE and all copies thereof and all other rights and interest including without limitation patents copyrights trademarks trade secrets and other intellectual property rights in and to the SOFTWARE and any copies thereof You have only the limited rights with respect to the SOFTWARE expressly set forth in this Agreement and You have no other rights implied or otherwise The structure organization and code of the SOFTWARE are valuable trade secrets of EI G and You shall keep such trade secrets confidential The SOFTWARE and User Documentation are licensed not sold 9 WARRANTIES AND DISCLAIMER a Limited Warranty If You follow the instructions the SOFTWARE will perform sub stantially as described in the EIG materials that you receive in or with the SOFTWARE b EIG warrants that any disks on which the SOFTWARE is supplied are free of defects in manufacture under normal use for 30 days after purchase During the 30 day period a defective disk may be returned upon authorization by EIG to an autho rized EIG distributor identified by EIG who will replace the disk without charge unless it has been damaged by accident or misuse Electro Industries Gauge Tech Docs
102. ific Day and click the pull down menu to open a calendar that lets you choose the day of the holiday that only occurs once Click the radio button next to Special Days to select a holiday that doesn t follow any of the above rules such as Easter d Click OK to save the holiday and return to the Holidays tab screen NOTES To edit a holiday click on the holiday in the list and click the Edit Selected Holiday icon You will see the same screen as when you are adding a hol iday but it will show the holiday s settings Change what you want and click OK to save the changes To delete a holiday click on the holiday in the list and click the Remove Selected Holiday icon You will see a Confirmation window asking if you are sure you want to remove the holiday click Yes to remove click No to keep the holiday B Electro Industries haugeTech Doc E167701 4 15 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings Fixed Charges A fixed charge is a charge that is added onto the bill Click the Fixed Charges tab to configure single charges you want to be applied to the commodity when the bill is generated c di ES CHAR Name SCE TOU 8 B Commodity kVAR Number of Seasons Two Seasons Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Season X Add Fixed Char
103. ill IMPORTANT e Path is the path to the application on your PC e You must include the quotation marks For example C Program Files x86 Electro IndustriesiEnergyReporter EXT BillViewer Bill Viewer exe script generate bill Electro Industries Gauge Tech Docs E167701 7 20 The Leader In Power Monitoring and Smart Grid Solutions A Sample Usage Summary Report A Sample Usage Summary Report EIG Engineering August 2014 Usage Summary Report Usage Summary Report for EIG Engineering August 2014 This report provides a summary of the kWh usage for EIG Engineering from Friday August 01 2014 to Sunday August 31 2014 This report was generated on Tuesday October 07 2014 Meter Report Each meter report contains 6 sub reports 1 Month Usage Summarizes the usage of the meter over the course of August 2014 from 08 01 2014 00 00 00 to 08 31 2014 23 59 00 All values presented are the computed 15 minute interval values of the recorded commodity kWh summed over the specified interval 4 values are presented a Total Usage The sum of all the 15 minute interval values over the period of the report b Peak Usage The peak 15 minute interval value over the period of the report c Month Usage A graph of the summed usage of each day during the period of the report d Month Trend A trend graph of the 15 minute interval values during the period of the report 2 Peak Week Usage Summarizes the u
104. ion checkbox is checked The city state and zip code of your location are displayed in the Address bar If more than one location is displayed choose the one that matches your customer s actual location Electro Industries Gauge Tech Docs E167701 The Leader In Power Monitoring and Smart Grid Solutions c Click Search to find the latitude and longitude of the location The location s information is displayed here click on this line to display the weather station information here r 4 Step 4 Configure the E Billing EXT Application Settings Location Weather Data Settings 7 Enable weather data collection Search Address Altoona PA 16601 Search City State Country Postal Code Latitude Longitude Altoona Pennsylvania 16601 40 51868 78 39474 Station Location Altoona Latitude 40 51868 Longitude 78 39474 Click Test to see weather and weather station d Click on the line with the location information The weather station informa tion is displayed in the section under Station If more than one location is displayed choose the one that matches your customer s actual location e Click Test to confirm that the selection is correct A screen opens with weather station information and weather readings f Click OK to close the window and save the settings Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4
105. ions are shown below Refresh click after Update Data icon to display changes Update Data click after making changes Click to clear an Invalid Flag from the currently selected data value Click to Delete Undelete the currently selected data value Click to export data see Section 6 1 1 Click to show data values that have been removed then you can click the Undelete icon and the Update Data icon to restore the value amp Bx o 6 1 1 Export Meters Data You can export meter data in two ways From the Edit Imported Data Screen shown in Section 6 1 only for EnergyRe porter Settings Editor l Click the Export Data icon shown above Output Layout amp CSV File Tabular Clipboard Format Column Separator Line Separator CRLF Include Column Headers Include Biling Event Information File Options Filename This screen lets you export the data to either the clipboard or a csv file Then you can copy the data into another application such as the Microsoft Excel application or use it in your own applications 2 Use the options in the Output box to specify where to export the data i Electro Industries Gauge Tech Docs E167701 6 5 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data e CSV File exports the data to a CSV Comma Separated Value Text file though you can select other than commas to separate the exported values When you sele
106. ist of all generated bills displays See the example screen below Bill Reports eo Save Bill View Bill Delete Bill Bill Period E Reports Bill Type Generate Date E Building 4 1 8 1 2013 9 1 2013 11 1 2013 11 02 AM E Building 6 8 1 2013 9 1 2013 11 1 2013 12 15 PM 2 Click on the sign next to the customer to display the location then click on the sign next to the location to display the bills for the location 3 Click on the bill you want to view and click the View Bill icon A PDF of the bill opens see the example bill on the previous page 4 You have the following options To save a copy of the bill on your computer click the Save Bill icon Bills are stored on the database server To get a local copy you need to save the bill on The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 5 27 5 Step 5 E Billing Dashboard Viewer your computer A screen opens which lets you choose the location of the saved bill and give it a filename To delete the bill click the Delete Bill icon A Confirmation window opens Click Yes to delete the bill click No to keep the bill WARNING Be careful when deleting bills Once you delete a bill it is removed from the server You can re generate the bill later You can delete multiple bills by selecting a range of bills and clicking Delete Make sure that you ve selected only the bills
107. ity Rollover Import settings from Meter log file Scaled Energy Q14Wh 100000000 E a a Add Channel Edit Channel Remove Channel Remove this Meter 7 Continue from step 13 in Section 4 4 4 4 2 Meter at Location Example If you have two meters at a location for example each metering a utility feeder you would set up both meters for the location following the instructions in this section When you import data the software will import all of the usage data for both meters and when the bill is generated the usage for both meters will be totalized to arrive at the billed dollar amount See the diagram on the next page Electro Industries Gauge Tech Doc E167701 4 50 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings Location Meter 1 E Billing EXT Application Imports data from meters Generates Bill for Location Bill Usage for Meter 1 and Meter 2 are on the Bill Charges for Meter 1 and Meter 2 are Totalized to Arrive at Total Billing Charge Figure 4 4 Totalizing Meters Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 4 4 3 Importing External Data If you are setting up the EnergyReporter EXT application for use with external dat
108. k and Off Peak rates for each season and you use the Rate Times tab to assign On Peak and Off Peak to different days and times of the day for each season Name Commodity kWh Number of Seasons Four Seasons Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Season Names Season Transition Dates Season One Summer March 21 Season Two Winter June 21 Season Three Season Three September 21 Season Four Season Four December 21 Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Weekdays Weekends A weekday is usually billed at a higher time of use rate than a weekend For this reason you can select what days are designated as a weekend in your jurisdiction Click the Weekdays tab to designate days as weekday or weekend this is the tab view you see when the screen first opens You use the Rates tab to set dif ferent rates for weekends and weekdays o da E E Name GS 1 Commodity kWh Number of Seasons Four Seasons Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Day Type Sunday Weekday Weekend Monday o Weekday O Weekend Tuesday Weekday Weekend Wednesday O Weekday Weekend Thursday O Weekday Weekend Friday Weekday
109. kbox to show the debug trace window while the software is running Display units in Dashboard select either Usage or Demand 3 Click OK to close the screen and apply your settings i Electro Industries Gauge Tech Docs E167701 7 15 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 4 4 Language This feature allows you to select a translation of the software to use as well as pro viding a tool that can be used to translate the software 1 Click the Language tab from the EnergyReporter Settings Editor or Dashboard Viewer Options screen Paths Configuration UI Language Language Select the Language to be used English USA Language File Information Create new Language 2 Select from the available languages from the pull down menu You can click Language File Information for details of the selected Language file 3 To add a new translation click the Create New Language button mm OOOO le Enter the new language name Swedish E Electro Industries haugeTech Docs E167701 7 16 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 4 Enter the language name and click OK File Tools Help Language Swedish Product Common Phrase Count 1619 Untranslated Phrase Count 1615 Outdated Translation Count 0 Last Update 7 2 2014 12 30 55 PM Phrase Remit
110. l see a screen showing the progress If there is a large amount of data this process may take a long time to complete e g it will take hours to restore a 20 Gigabyte database archive When the restore is done the window closes You can now re open the EnergyReporter EXT applica tion 7 2 4 Clear Database You can clear a database with this procedure WARNING Make very sure that you want to delete all of the data in the database before you click Delete Databases This command deletes all imported data and all configured settings including all bills and any changes you have made to data 1 From the Database Maintenance screen click the Clear Databases tab Warning This will delete all imported data and all configured settings All changes data and bills will be lost 2 Click the Delete Databases button i Electro Industries Gauge Tech Docs E167701 7 8 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 2 5 Server Status 1 From the Database Maintenance screen click the Server Status tab 2 You have three options Restart click this button to start the local database server after it has been shut down Shutdown click this button to close the local database server You see a window that shows the progress of stopping the server and then a win dow telling you that the software must be shutdown to finish stopping the server
111. le icon File Connection Real Time Poll Tools Logs View o ip Z retlog openlog conn mgr script mgr Click the Profile icon profile i The Device Profile screen for the meter opens See the example screen shown below Bl Shark200 Shark200T uniti Serial Number 014210 V Switch 4 File Tools View Help E General Settings E i ET PT Ratios and System Hookup c T PT Ratios and System Hookup Time Settings i System Settings CT Numerator Primary 2000 Update CT 400 Communications NS Display Configuration ES y Update Ratio gt 1 H Revenue amp Energy Settings CT Multiplier I h Power Quality and Alarm Settings h Trending Profiles Rati E Option Card 1 Comm PT Numerator Primary 1440 Update PT 120 Fiber Optic PT Denominator Secondary 120 Update Ratio gt Option Card 2 o Comm PT Multiplier 10 EB Network Voltage Full Scale 14 40k System Wiring 3 Element ye Hote To configure the CT amp PT settings either enter the Numerator Denominator and Multiplier or enter the Denominator followed by the Ratio for the CT or PT and click the update button to have the software fill in the Numerator Denominator and Multiplier Current Full Scale 2000 00 Minimum Voltage Threshold Enter the voltage value as a percentage of the voltage full scale between O and 12 7 o 0 a6 Based on the configuration of this screen the minimum prima
112. le name should be eight characters with an extension of three characters e g Nx1500 2 dbf Electro Industries hauge Tech Doc E167701 4 52 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings NOTES HMI EXT gatabases separate the original meter from the data so there is no way for the application to determine the rollover value Consult the HMI EXT configuration and documentation to determine the correct value to enter Your system integrator will have to provide you with the Energy or other commodity rollover value e f no rollover is programmed in the HMI EXT application the EnergyReporter EXT application rollover value should be the same as the rollover value in the meter s device profile set in the Communicator EXT 4 0 application in the meter s Device Profile Revenue and Energy Settings gt Energy Scaling Energy Uncompensated Energy Pulse amp ceumulatians and Aggregations Walt Hour VAR Hour Item Digits Decimal Places Units Example Quadrant 1 Wh i 1 kWh 9999999 9 Quadrant 2 Wh 1 kW h 3999999 9g Quadrant 3 Wh 1 kWh 3999999 9 Quadrant 4 Wh 1 kWh 9999999 9 h h Quadrant 114 Wh icc RUNS ERE 1 KW 3933333 9 Quadrant 2 3 Wh a 1 kwi 9999999 9 Net Wh uses Quadrant 1 4 Wh settings Global Settings OK Cancel Rollover Value i Electro Industries Gauge Tech Docs E167701 4 53 The Lea
113. lectro Industries Web Site ha Check for Software Updates End User License Agreement e HE amp A COMMUNICATOR profile retlog openlog conn mgr script mgr q armonic phasor log stats dev stats alarms Software License Configurator Give us Feedback Purchase a new Meter About Communicator Ext Connected Network TCPAP Addr 1 172 20 167 104 Shark200T unitl Modbus TCP 1 Open the Communicator EXT 4 0 application by clicking Start gt All Programs gt Elec tro Industries gt Communicator EXT You will see the screen shown above The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Doc E167701 3 1 3 Step 3 Set Up Logging 2 Click the Connect icon in the Icon bar to connect to the meter you are setting up Click Connect icon i Communicator Ext File Connection Real Time Poll Tools MVO Devices PU Calendar Logs View Help v om T4 CENE j ut profile retlog openlog conn mgr senptmgr connect dis cnct polling energy C Serial Port Dos Asa a RE ET ss 1 Enter Device Device Address Address Host 172 20 167 104 p 2 Enter Device s IP Address Network Port 50 Protocol Modbus TCP Connect Cancel 3 Click Connect Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 3 Step 3 Set Up Logging 3 From the Communicator EXT main screen click the Profi
114. ler VAppData VL ocallTemp ebillingext settings editor exe 10 Execute C Users ndeibler AppData Local Temp ebillingext settings editor exe 5 MullsaFE Install System vz d Next gt Cancel i Electro Industries Gauge Tech Docs E167701 1 12 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 9 When the application has been installed you will see the screen shown below Completing the EnergyReporter Ext 4 0 Setup Wizard EnergyReporter Ext 4 0 has been installed on your computer Click Finish to dose this wizard 10 Click Finish to close the Setup Wizard Electro Industries hauge Tech Doc E167701 1 13 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 11 To run the application select it from the Start menu Start gt All Programs gt Electro Industries EnergyReporter EXT gt Energy Reporter EXT Viewer or EnergyReporter EXT Settings Editor di Electro Industries E Automatic Export to Excel p Communicator Ext Manual E Communicator Ext Converter Activity Logs ol Data Files Log Viewer 3 Nexus Script amp Scheduler m EnergyReporter Ext J E EnergyReporter Ext Settings Edite 1 a6 EnergyReporter Ext Viewer Uninstall EnergyReporter Ext Sett 9 Uninstall EnergyReporter Ext Vie di MeterManager i Electro Industries Gauge Tech Doc E167701 1 14 The Leader In Power Monitorin
115. lick OK E E Click to Copy Export Print the graph data COMPARE Meter 1 Meter 2 To compare meter data click to select meter 1 and meter 2 Meter 1 Sample Customer 1800 Shames Dr Date May 2014 When you click Meter 1 or Meter 2 this window opens select the meter channel and date from the pull down menus and click Apply i Electro Industries GaugeTech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer You can also right click in a graph to open a sub menu Viewing Style 418 Border Style Font Size v Show Legend Numeric Precision 298 Glick to make Plotting Method C ad adj ustments to Data Shadows o graph display Grid Options Include Data Labels Mark Data Points at Undo Zoom Maximize Customization Dialog d l Click to export the graph or Export Dialog 118 graph data The following pages show examples of different graph selections i Electro Industries Gauge Tech Docs E167701 5 10 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer Two Meter Usage Comparison for One Month rcu ae EnergyReporter EXT Dashboard Viewer E Sm File Reports Tools Help o 1 Generate View Bills ocation Info Settings Editor All Bills Customers TE Usage Dashboard S torn MA
116. ly kWh usage interval data for 1 Building 1 Aggregated Meter October 2014 EE Building 1 ID ee B Building 2 Top Demand Usage vs Temp OPTIONS Day O Week Month Year Custom lt Nav De kh by interval ooo eee eee ES FE T T U Meter 2 Oct 2014 The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 5 8 5 Step 5 E Billing Dashboard Viewer The monthly usage is shown for the current month There are controls to the left of the Usage Dashboard See the diagram below for an explanation of the controls Usage Dashboard Control Panel TE COMPARE MAIN Temperature ESEG Click to view in the xil graph Usage Usage Cost Usage Cost Humidity Top Demand If you choose Usage vs Temp the Top Demand or Usage versus bottom of the controls panel Temperature changes as shown above to let you Usage vs Temp select temperature pressure or humidity data to see in the graph OPTIONS Click to select time range ma BENE for usage chart day peu Hange WeeR month year use 5 12014 B to 6 1 2014 Br 19 Month EI Nav buttons to go forward 7 Year and back in time Custom Click Nav buttons to go back and l lt E forward in selected time range ENS SEDI Opel window above select date Breakout Click Breakout to open the graph range you want to view data in a separate window for and c
117. mble the SOFTWARE iii Transfers You may not distribute rent loan lease sell sublicense or otherwise transfer all or a portion of the SOFTWARE or any rights granted in this Agreement to any other person or legal entity without the prior written consent of EIG iv Hosting or Third Party Use You may not install or access or allow the installation or access of the SOFTWARE over the Internet including without limitation use in connection with a Web hosting commercial time sharing service bureau or similar service or make the SOFTWARE available to third parties via the Internet on Your computer system or otherwise V Notices You may not remove alter or obscure any proprietary notices labels or marks from or on the SOFTWARE The Leader In Power Monitoring and Smart Grid Solutions Electro Industries Gauge Tech Docs E167701 iv vi Modifications You may not modify translate adapt arrange or create derivative works based on the SOFTWARE for any purpose vii Circumvention You may not utilize any equipment device software or other means designed to circumvent or remove any form of copy protection used by EIG in connection with the SOFTWARE or use the SOFTWARE together with any authoriza tion code serial number or other copy protection device not supplied by EIG directly or through an authorized distributor In the case of a network version You may not utilize any equipment device software
118. n Automatic Scan Configuration Enter IP address range Unless this computer is the Set IP range to scan 172 20 160 0 gt 172 20 167 255 f Log Collection V Disable Automatic Log Automatic Log Retrieval should only be enabled on one or meter server leave Retrieval computer on a network If this is the server or only discove ry here computer enable this Otherwise this should be left this box checked disabled 4 Automatically assign newly found meters to groups based on meter type Leave this check box selected if you want meters put in groups by meter model e g Shark Click Save to begin scan with selected settings 2 In the Automatic Scan Configuration screen you set e The IP range in which you want the application to search for meters the starting and ending IP addresses NOTE EIG meters use Modbus for communication which defaults to Port 502 However if you have changed the Modbus port on the meter or are using a network device that changes the port mapping you can specify the port range to scan by adding port after the IP address For example range 192 168 0 1 503 to 192 168 0 255 505 will scan all IP addresses from 192 168 0 1 to 192 168 0 255 and attempt to connect to those IP addresses via ports 503 504 and 505 The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Doc E167701 2 2 2 Step 2 Use MeterManager EXT to Automate En
119. n Info Settings Editor All Bills Customers Usage Dashboard Be 15C Locations MAN Comparison of weekly kWh usage interval data and Pressure for B College Park Apartment Sample Customer amp 1800 Shames Dr Office JK 5 4 2014 E 1800 Shames Dr 2 College Park Apartment OPTIONS Nittany Point Apartment n Pressure Day O Week C Month Year Custom Aj Nav BP kh by interval qui auinssald 7 Wed 8 Thu 9 Fri 10 Sat 11 Sun May 2014 Usage Versus Weather Humidity for One Day 6 EnergyReporterEXT Dashboard Viewer loss File Reports Tools Help e Generate View Bills ocation Info Settings Editor All Bills Customers Usage Dashboard E Locations MAIN Comparison of daily kWh usage interval data and Humidity for B College Park Apartment Sample Customer 1800 Shames Dr Office JK 5 7 2014 ENS oh m Humidity Be 15C E Sample Customer E Locations Top Demand dg 1800 Shames Dr o Usage vs Temp College Park Apartment Nittany Point Apartment kWh by interval 06 AUPILUNH lt Nav gt J 7T Wed May 2014 The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries GaugeTech Doct E167701 5 Step 5 E Billing Dashboard Viewer 3 To exit the usage dashboard click the Location Info icon at the top of the screen 5 3 Generating and Viewing Usage Reports The Executive Summary Usag
120. nday Weekday Weekend Monday o Weekday Weekend Tuesday o Weekday Weekend Wednesday o Weekday Weekend Thursday o Weekday Weekend Friday o Weekday Weekend Saturday Weekday o Weekend Store Exit 4 After selecting Seasonal Schedule you ll see the screen above Use this screen to set up all of the information for this rate Do the following Enter a name for the rate structure this name will appear on the bill e Select Commodity from the pull down menu A commodity is a usage value the software uses when computing the rates for a bill from the imported Energy or other commodity data You can select an existing commodity or Create New For Energy usage select kWh When the bill is generated the software uses the rate structure for the commodity e g kWh to determine the charge for the amount of usage the customer has for the billing period e g total kWh The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 4 9 4 Step 4 Configure the E Billing EXT M Application Settings If you select Create New you will see the screen shown below which lets you set up a new commodity to use Edit Commodity Information Name Scalar k 1000 omes a Enter a name for the new commodity b Select the scalar from the pull down menu you can select Unit 1 k 1000 M 1000000 or Custom Infinity If you select custom
121. ng either the Communicator EXT application databases or the HMI EXT application s polling engine see the HMI EXT User Manual and the Communicator EXT 3 0 User Manual for additional infor mation on these applications The EnergyReporter EXT application was created for use with Electro Industries Shark amp 200 and 200S meters the MP200 metering sys tem and all Nexus 8 series meters The EnergyReporter EXT application performs complex calculations such as multiple entity aggregation and supports user pro grammable rate and tariff structures This robust application allows for generation transmission distribution and tax charges and can be used for steam and other commodities as well as electrical billing It also supports detailed usage analysis in the form of usage reports and trending charts The EnergyReporter EXT application has three parts EnergyReporter Settings Editor the part of the application you use to set up bill ing including customer and location configuration data import rate configuration and correcting errors in the imported data e EnergyReporter Dashboard Viewer the part of the application you use to view the Energy Dashboard generate and view bills view and analyze usage data and gen erate and view usage reports e Database Server the part of the application which provides access to the billing database New to EnergyReporter EXT V 4 software are the following features e Suppo
122. not generated rt Generated 5 7 2014 rt not generated rt not generated rt Generated 4 22 2014 rt Generated 4 23 2014 rt Generated 4 23 2014 rt Generated 4 23 2014 rt Generated 4 23 2014 rt not generated Sample Customer kWh April 2014 April 2014 Report not generated 2 This screen lets you view all of the months with usage data for customer locations Click on the signs next to customer location and commodity to see the list of months Double click on a month to view its usage report or click on the month and click the View Report icon See the sample report in Appendix A If the report hasn t been generated yet for the month it is generated when you select it 3 You can also Click the Options icon to change output options before you generate another usage report e g if you want to use a different format for the report You will see the Output Options screen shown in Section 5 3 2 step 4 Click the Save Report icon to open a window that lets you choose a filename and a save location for a copy of the report i Electro Industries Gauge Tech Docs E167701 5 19 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 4 Generating and Viewing Customer Bills You use the EnergyReporter EXT application s EnergyReporter Dashboard Viewer to generate and view bills See the diagram below EnergyReporter Database Server Billing Dat
123. nstallation Select components to install Settings Editor Bill viewer Database Server Space required 36 4MB 5 You have two options for the database server e Local Only the database server is installed under the current user and is only run when the client software EnergyReporter Settings Editor EnergyReporter Dashboard Viewer is run Additionally the database server is only accessible from the local machine and only by the installing user This is primarily used when installing under restricted accounts standalone systems or on laptops Bills and reports must be manually generated e Network Server the database server is installed under a special user as a service The database is accessible from other machines on port 5432 and is started when the computer starts This is the default installation setting and allows users on other computers to access the database This setting requires that the installing user have permission to create users and set up services This is a Client Server application and as such you may need administrator help to install the software in this mode Bills and reports are automatically generated i Electro Industries Gauge Tech Docs E167701 1 7 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application The diagrams below and on the next page show the differences between the Local and Network database server functionality Import Data
124. nt the billing period to begin and then click OK The Bill Period screen closes and the day you chose is displayed in the Edit Location Information screen 5 Add the Location address 6 Click Apply to create the location A window opens with weather data information based on the address you entered for the location and asking if you want to enable automatic weather data updates The EnergyReporter EXT application can get weather data for your locations that The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 4 38 4 Step 4 Configure the E Billing EXT M Application Settings you can then use to compare commodity usage against temperature humidity and barometric pressure Weather data is collected from an online weather data service provider The service uses the latitude and longitude of your location to find the closest weather station The latitude and longitude for this location s address is displayed in the window Verify that the discovered weather location is correct and then click Yes to enable automatic weather data updates click No if you don t want to automatically update or if you want to configure weather data collection manually instructions on page 4 41 Edit Location Information Location Name College Park Apartments Bill Period 6th of the month Location Address 200 Wopsononock Avenue Altoona PA 16601 Weather Data Settings Weath
125. nual i Electro Industries Gauge Tech Doc E167701 2 9 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT This page intentionally left blank Electro Industries hauge Tech Dock E167701 2 10 The Leader In Power Monitoring and Smart Grid Solutions 3 Step 3 Set Up Logging 3 Step 3 Set Up Logging In most cases there is no need to do anything special to set up logging for the Ener gyReporter EXT database This is because all EIG meters ship with a default Device Profile that logs energy values As long as you haven t changed this the automatic log retrieval set for the meters using MeterManager EXT will get all the data that the EnergyReporter EXT application needs in order to generate usage reports However in the event that you need to make a change you set up Energy Energy in the Interval and other Commodity logging in the meter s Device Profile accessed through the Communicator EXT 4 0 software NOTE Only the basic steps are given here For more detailed information consult the Communicator EXT 4 0 and MeterManager EXT Software User Manual you can access the manual online by clicking Help Contents in the Communicator EXT 4 0 Menu Bar 1 Click Help 2 Click Contents to view manual a E Communicator Ext 1 File Connection Real Time Poll Tools Logs View e Contents a v E E
126. o not need this information continue to step 8 on page 4 31 Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 Step 4 Configure the E Billing EXT M Application Settings 6 To set up a rate structure with Fixed Charges only no Time of Use such as On Peak Off Peak Seasons Weekend Weekday or Holiday rates select Flat Rate from the Add Rate Structure pull down menu Add Rate Structure Please choose the type of rate structure to add Rate Structure Type Flat Rate Rate Structure Name Commodity Fixed Charges Add Fixed Charge Flat Rate Flat Rate Edit selected Fixed Charge Remove selected Fixed Charge g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 29 4 Step 4 Configure the E Billing EXT M Application Settings a Enter a Name for the Rate Structure select the Commodity it will be applied to from the pull down menu and click Edit Selected Fixed Charge Fixed Charges Charge Type Flat Rate Flat Rate Name Flat Rate 2 Flat Rate 40 A Flat Rate is a charge which applies to the total usage such as a Generation Charge or a Fuel Surcharge The rate is multiplied by the total usage for the commodity b Keep the Charge Type as Flat Rate and enter a Flat Rate Name an
127. ocations 6 11 6 4 Rebuild Period Analysis 6 11 i Electro Industries Gauge Tech Docs E167701 TOC 2 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 1 7 1 Viewing the Action Log 7 1 7 2 Database Maintenance 7 3 7 2 1 Database List 7 4 7 2 2 Archive Database Clusters 7 5 7 2 3 Restore Database Clusters 7 6 7 2 4 Clear Database 7 8 7 2 5 Server Status 7 9 7 2 6 DB Actions 7 10 7 3 Clear Meter Data 7 11 7 4 Option Screens 7 12 7 4 1 Path Setting 7 12 7 4 2 Configuration Setting 7 13 7 4 3 Ul User Interface Setting 7 15 7 4 4 Language 7 16 7 5 Performing Tasks Using Command Line 7 20 7 5 1 Import Data Using Command Line 7 20 7 5 2 Generate All Bills Using Command Line 7 20 A Sample Usage Summary Report A 1 Glossary GL 1 Table of Contents Doc E167701 i Electro Industries Gauge Tech TOC 3 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents This page intentionally left blank g Electro Industries haugeTech Doc E167701 TOC 4 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 Step 1 Install the EnergyReporter EXT Application 1 1 Overview The EnergyReporter EXT application is a fully customizable software application that lets you create and view an Energy Dashboard analyze costs and automatically gen erate detailed Energy usage reports and usage bills usi
128. omers and meters at locations as well as commodities and rate structures that will be applied to usage The MeterManager EXT application automatically downloads the logs from the selected meters and the EnergyReporter EXT application automati cally imports the commodity usage data from the logs The EnergyReporter EXT application generates the bills and usage reports based on the billing period and report criteria you have set up using the EnergyReporter Settings Editor The EnergyReporter Dashboard Viewer is the part of the EnergyReporter EXT applica tion that lets you see print and export billing and usage information for the custom ers locations and meters As mentioned in Chapter 4 locations with multiple meters generate a virtual meter to store aggregated meter data The Aggregate Meter s data can also be accessed from the EnergyReporter Dashboard Viewer Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 1 Accessing the EnergyReporter Dashboard Viewer 1 Click either the Dashboard Viewer icon from the top of the EnergyReporter Settings Editor screen or the Launch Bill Viewer icon from the EnergyReporter Settings Editor main screen p E EnergyReporter EXT Settings Editor pco s File Configure Tools Help o 80 j m la Add Edit Edit Import Dashboard Customer Rates Provider All Logs Viewer E Automa
129. or enforceability of such provision in any other jurisdiction or affect the legality validity or enforceability of any other provision of this Agreement 14 NO WAIVER No term or provision hereof will be considered waived and no breach excused unless such waiver is in writing signed on behalf of the party against whom the waiver is asserted No waiver whether express or implied will constitute a con sent to waiver of or excuse of any other different or subsequent breach 15 AUDITS To ensure compliance with this Agreement You agree that upon reason able notice EIG or El G s authorized representative shall have the right to inspect and audit Your Installation Access and use of the SOFTWARE Any such inspection or audit shall be conducted during regular business hours at Your facilities or electroni cally either by EIG or by representatives authorized by EIG for this purpose If such inspections or audits disclose that You have Installed Accessed or permitted Access to the SOFTWARE in a manner that is not permitted under this Agreement then i You are liable to pay for any unpaid license fees as well as the reasonable costs of the Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions viii audit and ii without limitation of Section 1 Grant of License and unless EIG other wise elects in writing the license grant with respect to the SOFTWARE will terminate immedia
130. origi Electro Industries Gauge Tech Docs E167701 4 31 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings nally generated If you choose not to archive the edited rate structure regenerating the bill will use the rates as defined in the newly edited rate structure Once a rate structure has been archived the archived copy may not be edited again f a rate structure has been archived it will be used to generate cost data in the Usage Dashboard cost graphs for the billing periods when the archived rate structure was still in effect This rate structure has already been used to generate a bill Do you want to archive a copy of the rate structure that was used during the last bill generation so that the bill can be reproduced with its original rate structure If you choose not to save a copy and you reissue a bill this new rate structure will be used D o you want to archive a copy of this rate structure before saving changes Archive Rate Structure Screen Click Yes to Save the Rate Structure i Electro Industries Gauge Tech Docs E167701 4 32 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings To delete a rate structure click on the rate structure and click the Remove the Selected Rate Structure icon You will see a Confirmation window asking if you are sure you want to remove th
131. ort Customer Housing International Location Houses1 Date August 2013 Report Type Channel kWh Generate for all customer locations Report Options Display Demand Reports to include 4 Report Overview W Monthly Usage Summary v Highest Usage Meter Comparison 4 Usage At a Glance 4 Meter Total Usage during Month W Meter Total Usage during Peak Week W Meter Total Usage during Peak Day W Meter Average Hourly and Daily Usage Generate 3 Select the channel from the pull down menu 4 Note that the location you are currently viewing is displayed at the top of the screen That is the only location whose data will be shown unless you select Generate for all customer locations by clicking in its checkbox 5 f you want to see demand in your report select Display Demand by clicking in its checkbox 6 Click the checkboxes of the data you want included in the report By default all of the data is selected Click on a box to uncheck it if you don t want that data in your report 7 Click Generate You will see a message while the report is being generated and then it will display on the screen A sample Executive Summary Usage Report follows i Electro Industries Gauge Tech Docs E167701 5 15 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 3 2 Generate Usage Reports Click Reports in the EnergyReporter Dashboard Viewe
132. ovider Upgrade License Edit your Bill Provider Electro Industries hauge Tech Doc E167701 1 16 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application This window opens Current License User billing Unique ID 15CABF37AS4ABCCB348FD045C17995B5ACA438D021A2FEDBCTOF6180FD3E24FDD Expiration Date 2014 11 01 Permissions bill settings config permission view setting view bill settings config license unlimited normal license sales demo license normal Upgrade License License Key Upgrade Enter license key here and click Upgrade 2 Contact EI G s inside sales staff at sales electroind com In the email give your name company name and the Unique ID code shown in the License Info screen You will receive a reply email with the software license key 3 Enter the software license key and click the Upgrade button The software will be upgraded to the full version of the application i Electro Industries Gauge Tech Doc E167701 1 17 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 5 Steps for Using the EnergyReporter EXT Application As mentioned at the beginning of this chapter the EnergyReporter EXT application generates bills using either Communicator EXT log databases or the polling engine of the HMI EXT application Because the HMI EXT application is specifically config ured for each customer site data setup for
133. p Se 2 m O 5 c 2 m OA 5 c 5 m v 2 5 c zn 5 c son 49 a 8 5 3535 aea 8 a 8 a 9 a 9 a 8 53535 0c 25 2955 7 oc 25 2550 eke FE 25 kt 5 saca 255 05 2c awg C on e kWh usage per Day e 5 ch ERE D E fe EN NEN NN A RN NN TESI ERE RII SS ERIT ES UNIUS ER AR AR O E E D D L CLET NE E a a a E Co B m INI URINE CINE REIN A a ES 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 3 2 9 10 11 12 13 14 15 16 17 18 18 20 21 22 23 24 25 26 27 28 29 30 91 Aggregated Meter Average hourly and daily usage Aggregated Meter Usage comparison to previous month and year j n_a A EIG Engineering August 2014 Usage Summary Report Main Building Aggregated Meter Monthly Usage and Temperature Displays a comparison of monthly usage and temperature The highest and lowest temperature for each day over the course of the month are determined and displayed as the bounding lines in Red and Green Figure 1 6 Monthly Usage and Temperature EN Usage Per Day Max Temperature Min Temperature q Cn e J e e C c e SS a ee p p n y i EE NM i i ge ga aS tp RN es n ee a aai NNI a RN La E i A c c c e e e C e e kWh usage per Day LA NN EN NE Wayuauues Bag aumeJadula E Cn e I e e e co Cn e Dd eee ee is a a es ae EC 8 ee EE ES ee AMI DM Ja
134. pter 7 View the Action log test the application and learn additional tips and advanced options B Electro Industries haugeTech Doc E167701 1 18 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT You use the MeterManagerEXT application to organize your meters and to set up auto matic log retrieval both of which make the EnergyReporter EXT application very sim ple to use The MeterManager EXT application lets you automatically add all of your network meters to its Meter List The Meter List is an essential feature for the EnergyRe porter EXT application All you have to do to set up your billing locations is to add meters to it from the Meter List All of the meter data you need is then automati cally brought into the EnergyReporter EXT application The MeterManager EXT application lets you set up automatic log retrieval for all of your meters NOTE The basic steps are described here but there are other features of the MeterManager EXT application which are covered in the Communicator EXT 4 0 and MeterManager EXT Software User Manual There are two ways to add meters into the Meter List l Auto Discovery this is the simplest method In this mode the software searches out and locates any meters on the network Once the meters are found they are automatically added to g
135. r main screen s Menu bar You will see the submenu shown below View Bills View Usage Reports Generate Bills Generate Usage Reports There are two Report options Generate Usage Reports and View Usage Reports 1 Click Reports Generate Usage Reports gt Generate Customer Report You will see the screen shown below Customer Start of Month 1st Channel Month June 2013 July 2013 August 2013 September 2013 October 2013 Generate 2 Select the customer start date for the month and channel The Month box fills with the available months for the customer the months which contain usage data 3 Click each of the month s you want to create the usage report for Electro Industries Gauge Tech Doc E167701 5 16 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 4 Click Options You will see the screen shown below Usage Report Options Output Options Output Path tro Industries YE Billing Ext Reports Usage Browse Use default report name File Format PDF Report Content Options Report Commodity kWh Single Page Summary Overlay Interval Data Colorize TOU Colorize Periods Display Demand 5 Configure the following settings e The default path is displayed in the Output Path field Click the Browse button if you want to choose another output path for the file This is where the report will be saved e
136. r point and the current value is near zero This is not considered an error e Increasing Too Fast show values flagged as increasing too fast Values which are increasing more then 3 times the trend in the previous hour are considered as increasing too fast and might indicate a problem This is considered an error and must be cleared before a bill can be generated Decreasing Counter show values flagged as a decreasing counter Except for the Rollover condition counters such as Energy and pulse accumula tors used for Commodities should never decrease If they do this indi cates a problem and must be cleared before a bill can be generated Good Values show values which are not flagged with an error condition 4 Once you ve selected the filters you want to use click View The data is retrieved from the database and displayed Values which are flagged as a warning are shown in Green Values which are errors and will prevent a bill from being generated are g Electro Industries haugeTech Doc E167701 6 3 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data shown in Red See the example screen below 3 9 2014 12 15 AM 3 9 2014 12 30 AM 3 9 2014 12 45 AM 3 9 2014 1 00 AM 3 9 2014 1 15 AM 3 9 2014 1 30 AM 3 9 2014 1 45 AM 3 9 2014 3 00 AM 3 9 2014 3 15 AM 3 9 2014 3 30 AM 3 9 2014 3 45 AM 3 9 2014 4 00 AM 3 9 2014 4 15 AM 3 9 2014 4 30 AM 3 9 2014 4 45 AM 3 9 2014 5
137. r the data errors When scan ning is done any errors will display on the left side of the screen along with the meter and timestamp The fields on the left display the Error Description field and detailed information regarding the error and ways to handle it are displayed on the right side of the screen See the example below Scan and Edit Data Errors Edit Data Point Timestamp i4 0000000020375 6 10 2013 5 45 PM Interval value decreasing but n 0000000020375 6 10 2013 5 45 PM Interval value decreasing but ni 0000000020375 6 10 2013 6 00 PM Counter values decreasing for r 0000000020375 6 24 2013 8 45 AM Interval values are missing in th 0000000020375 7 15 2013 8 30 AM Interval values are missing in th Main CPU 2 8 2013 9 28 AM Interval values are missing in th Main CPU 2 21 2013 11 59 AM Interval values are missing in th Error Description Timestamp 6 10 2013 5 15 PM 8E 05 6 10 2013 5 30 PM 9E 05 6 10 2013 5 45 PM 9E 05 Interval value decreasing but no rollover detect 6 10 2013 6 00 PM 9E 05 Ww 6 10 2013 6 15 PM Error Description Poller 12 14 2012 2 00 PM Interval value interpolated Poller 12 14 2012 2 00 PM Interval value interpolated Poller 1 2 2013 11 48 AM Interval counters are missing in 4 1700ShameDr 6 10 2013 5 45 PM Interval value decreasing but ni New Value 0 Update Interpolate 1700ShameDr 6 10 2013 5 45 PM Interval value
138. re Script Status B 9 NOTE If the MeterManager EXT application is running downloading meter logs you will see Script Service Running at the bottom right of the screen Click on the mes sage to either pause the MeterManager service or open the MeterManager Monitor See Chapters 18 of the Communicator EXT 4 0 and MeterManager EXT Software User Manual for additional information Follow these basic steps to set up the EnergyReporter EXT application 1 Set up provider information The provider is the person or organization which is providing the energy sending the bill and receiving payments This information appears on the generated bills so that the customer knows where to send payment i Electro Industries Gauge Tech Docs E167701 4 1 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings 2 Set up rate structures The rate structure is the collection of settings that deter mine what rates to apply to the usage values for a commodity e g kWh The rate structure includes On Peak and Off Peak settings holidays and other charges such as taxes 3 Set up a customer A customer is the person or organization which is receiving the bill A customer may have multiple locations each of which will get its own bill 4 Set up the customer s locations A billing location is a single unit for which a bill is generated e g a building A cus
139. regated Meter Total usage during month Main Building Aggregated Meter Total Usage during Peak Week 08 10 2014 to 08 16 2014 Total Usage Peak Usage o e o p E gt N o OD is un I N as 5 ON Ss lt EIG Engineering Figure 1 2 3929 14 Sat 16 Wed 13 n EB E a r y xi L aBesn UA JO pua ajnulul 6 sat 16 Fri 15 Thu 14 Wed 13 Tue 12 Mon 11 Aug 2014 Aggregated Meter Total usage during Peak week 756 Main Building Aggregated Meter Total Usage during Peak Day Monday August 11 2014 E o o p Pr fem ES g Nn o en c un gt I lt D N ee un bn 5 lt EIG Engineering Figure 1 3 14 Total Usage Peak Usage es E E E E de mmml Lain i nii O Ln c c C Li ML 7 Ln n i i wil C3 L e Lii di UU SS X C Li e e Cd Loin n i inl Jo 0 e CO O O wu sf QM 21 00 e ay po meu d enis ess 3 00 o n 11 Aug 2014 M VV i a i pe m E Aggregated Meter Total usage during Peak day EIG Engineering August 2014 Usage Summary Report Main Building Aggregated Meter Average Hourly and Daily Usage Displays the average usage over the course of the month averaged by hour and by weekday The
140. roups based on the meter type and the software auto matically begins to download stored meter data 2 Manual Connect in this mode you manually connect to the meter using its IP address Once the address is entered the software adds it to a group based on the meter type and automatically begins to collect stored meter data for that meter 2 1 Add Meters to the Meter List Using Auto Discovery There are two methods to configure Auto Discovery Use whichever one best suits your needs e Auto Scan searches an IP range you enter for network meters and adds them to the Meter List B Electro Industries haugeTech Doc E167701 2 1 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT Meter Discovery Configuration gives you access to additional settings for custom izing scanning for meters See Chapter 18 in the Communicator EXT 4 0 and MeterManager EXT Software User Manual for instructions for using Meter Discovery Configuration When you use Auto Scan the application looks for and adds Network meters in the IP address range you enter You have the option of putting the meters into groups based on meter type e g Shark NOTE The first time you start the MeterManager Monitor after installation you are asked if you want to enable Auto Scan EIG recommends that you do enable Auto Scan 1 Click the Auto Scan icon at the top of the scree
141. rt from MeterManager EXT software allows for meter and logging automation and management Updated Dashboard layout B Electro Industries haugeTech Doc E167701 1 1 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application Weather data added to provide weather vs load comparisons Meter aggregation feature and virtual meters Ability to archive rate structures that have changed Ability to set up seasonal Fixed charges Ability to set up Tiered rates Ability to export meter s data New reporting capabilities e New technical tools 1 2 Installing the EnergyReporter EXT Application EnergyReporter EXT software can be run either as a standalone program the data bases are stored on the computer that is running the application or in a Client Server format the databases are stored on the Server and the application is run on the Client PCs Note that the Client PCs can use the Dashboard Viewer but cannot use the Bill Settings Editor See your System Administrator for the setup you will be using IMPORTANT The EnergyReporter EXT application utilizes the MeterManager EXT automation component which is installed as part of the Communicator EXT 4 0 or higher application You must have a licensed version of the Communicator EXT 4 0 software installed on the PC that will function as the Server The shareware LITE version does not have the MeterManager EXT automation component
142. ry voltage wil be 1200 00 save Profile Load Profile view Report Shark 200 Meter Device Profile Screen 4 For the Shark meters and the MP200 metering system click on the sign next to Trending Profiles for the Nexus meters click the sign next to Trending Profile Settings and then the sign next to Trending Setup You will see a list of historical trending logs i Electro Industries Gauge Tech Doc E167701 3 3 The Leader In Power Monitoring and Smart Grid Solutions 3 Step 3 Set Up Logging Double click on the log you want to use to trend energy or other usage You will see a screen that lets you select the values you want to log Refer to the table below for the values to select for energy logging NOTE For the MP200 metering system there is only one historical log for use with the EnergyReporter EXT application either historical log 2 for the MP200 Y three phase configuration or historical log 3 for the MP200 S single phase configuration The log is pre configured with the data points you need for logging Table of Settings for Logging Energy Energy in the Interval and Commodity Group Sub group Data Point Interval n Interval Shark Energy Energy in the Accumulators Watt hours Watt hours Input used Interval Received Received for accumulation Accumulators Interval Internal Pulse Quadrant Quadrant Input used Energy Accumulators Accumulation 1 4 Wh 1 4 Wh for Scaled Energ
143. sage of the meter over the course of the peak week during August 2014 The peak week is defined as the week containing the peak day All values presented are the computed 15 minute interval values of the recorded commodity kWh summed over the specified interval 4 values are presented a Total Usage The sum of all the 15 minute interval values over the period of the peak week b Peak Usage The peak 15 minute interval value over the period of the peak week c Usage over the Week A graph of the summed usage of each day during the peak week d Trend over the Week A trend graph of the 15 minute interval values during the peak week 3 Peak Day Usage Summarizes the usage of the meter over the course of the peak day during August 2014 The peak day is defined as the day which has the highest total usage All values presented are the computed 15 minute interval values of the recorded commodity KWh summed over the specified interval 3 values are presented a Total Usage The sum of all the 15 minute interval values during the peak day b Peak Usage The peak 15 minute interval value during the peak day c Usage over the Day A graph of the 15 minute interval values during the peak day 4 Average Hourly and Daily Usage Displays the average usage over the course of the month averaged by hour and by weekday The highest and lowest usage for each hour and weekday over the course of the month are determined and displayed as the bo
144. settings from a CommExt log database Meter List Commodity Rollover Selected ings fi Meter log fil W hours Received f Los Loc meter S first energy Add Channel channel data Edit Channel C h ann el icons Remove Channel Remove this Meter Re m Ove Meter icon Values Saved 13 After the meter settings are imported from the meter s log file and you click Apply the first energy channel is selected and displayed in the Channel fields A channel is a single type of data item from the meter s log database e g Watt hours Received The channel will be linked to a commodity for use in generating bills e g the Watt hours Received channel linked to the kWh commodity The Channel icons let you add channels edit them or remove them To add a channel Click Add Channel Select the meter log channel to use for the commodity Meter Channel Commodity Rollover unscaled E Auto adjust Rollover Percentage of usage applied 100 Adds or subtracts a 5b of to bill the meters usage to the 14 Select the channel from the pull down menu The channels you see are the data values that you set up for this log using the Communicator EXT 4 0 application g Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Dock E167701 4 45 4 Step 4 Configure the E Billing EXT M Application Settings They are channels for Energy and or pulse accumulations See Section 4 4 3 for channel settin
145. t the software now e 6 Click Yes to restart the EnergyReporter EXT software now click No if you don t want to restart the software NOTE Changes you make won t take effect until you restart the software Electro Industries Gauge Tech Doc E167701 7 14 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 4 3 UI User Interface Setting Except for one setting the EnergyReporter Dashboard Viewer and EnergyReporter Settings Editor Option screens have the same UI settings 1 Click the UI tab The screen shown below is from the EnergyReporter Dashboard Viewer The Options screen from the EnergyReporter Settings Editor does not have Display option Configuration Enables Warn on software close Warn on startup if the root path is invalid 7 Show debug window Display Display units in Dashboard 2 These are the setting options e Warn on software close this setting asks the user to confirm closing the soft ware The default of the setting is checked selected To un select the setting click on the checkbox to remove the checkmark Warn on startup if the root path is invalid this setting verifies that the database server has been configured correctly and is accessible The default of the setting is checked selected To un select the setting click on the checkbox to remove the checkmark this is not recommended e Show debug window click the chec
146. te the bill by identifying which rate is applied to the usage for the specific time period e g if you set Season 1 Weekend time intervals as all Off Peak then any usage for Season 1 weekends is charged the Off Peak rate Rate Structure Name Commodity Number of Seasons Two Seasons Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Weekday Season One Weekend Season One Weekday Season Two Weekend Season Two Select a rate group to edit it s assigned rates Store i Electro Industries Gauge Tech Docs E167701 4 25 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings a Click on one of the groups to display its settings on the right side of the Screen Rate Structure Name Commodity Right click in this box to Number of Seasons Two Seasons display a menu allowing multiple selections Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Weekend Off Peak On Peak Weekday Season One Weekend Season One SPESIES Weekday Season Two Weekend Season Two i 3 Select a rate group to edit it s assigned rates b Click in the Off Peak or On Peak box next to a time range to change its set ting You also have the following multiple selection options You c
147. ted Energy Reporting ag Cost Analysis and Usage Billing E Locations amp Bs Building 1 t Meters Aggregated Meter MAIN MENU 1500100 MAIN MENU d 1800ShamesDr ee eee es Import All Logs t Party who will receive the bill Import your data logs to view amp Office DS amp Office JK Jm Edit Rate Structures Edit or Modify billing Rate 6 Office JS Structures 4 xn Edit Provider Edit your Bill Provider Office RM dit your Bill Provide E Office RP 552200 unite Bs Building 2 Meters E M Shark200T unit1 7 Script Status B 9 NOTE You can click Tools gt Refresh to return to the main screen display from another screen e g the Location screen Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 2 The EnergyReporter Dashboard Viewer application starts and you see the main EnergyReporter Viewer screen Choose a location from the tree on the left side of the screen E E File Reports Tools Help e lus A E Generate ViewBills Usage Dashboard Settings Editor All Bills m Customers E T Location Information E Locations BP Building 1 Select a location from the left to begin m Bi Building 2 agp ick on the location you want to see Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 St
148. ted bills See Section 5 4 Usage Dashboard display the Usage Dashboard see Section 5 2 i Electro Industries Gauge Tech Docs E167701 5 5 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer Settings Editor open the EnergyReporter Settings Editor application See Chapter 4 The menu items at the top of the screen let you e File select to connect to the database or exit the EnergyReporter Dashboard Viewer Reports view or generate bills and usage reports per selected criteria See sections 5 3 and 5 4 Tools view bill data view bill errors for locations export meter data perform advanced tasks see chapters 6 and 7 e Help check for updates see User Manual see information about the application version read the User License Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 E Billing Dashboard Viewer 5 2 Usage Dashboard One of the important features of the EnergyReporter EXT application is the Usage Dashboard It supports an Enterprise wide billing solution by allowing you to easily view Energy and other commodity usage data in a number of formats View usage by day week month year or by a customized date range e Compare usage between meters locations e Compare usage against weather data e View costs e View top Demand by day week month year or by
149. tely Any information obtained by EIG or El G s authorized representative during the course of such inspection and audit will be used and disclosed by EIG solely for purposes of such inspection and audit and for enforcement of El G s rights under this Agreement and applicable law unless other uses or disclosures are required under applicable law Nothing in this Section shall be deemed to limit any legal or equitable remedies available to EIG for violation of this Agreement or applicable law 16 CONSTRUCTI ON Ambiguities in this Agreement will not be construed against the drafter Should you have any questions concerning this Agreement please contact Electro Industries GaugeTech at 1800 Shames Dr Westbury New York 11590 USA This legal document is an Agreement between you as the end user of SOFTWARE and Electro I ndustries GaugeTech EIG Electro Industries Gauge Tech Doct E167701 The Leader In Power Monitoring and Smart Grid Solutions This page intentionally left blank i Electro Industries GaugeTech Dock E167701 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents Table of Contents Customer Service and Support ii Disclaimer ii About Electro Industries GaugeTech ii License Agreement for the EnergyReporter EXT Software Application iii IX 1 Step 1 Install the EnergyReporter EXT Application 1 1 1 1 Overview 1 1 1 2 Installing the EnergyReporter EXT Application 1 2 1 2 1 Installa
150. the EnergyReporter EXT application is done when the HMI EXT application is installed and configured by a certified system integrator You already performed Step 1 in this chapter You need to perform the following steps in order to set up the database files to be used for Energy and other commodity logging and to use the EnergyReporter EXT application to generate usage reports and bills Step 2 Use the MeterManager EXT application to set up your meters for automatic log retrieval Instructions for this step is given in Chapter 2 additional information is located in chapters 16 and 18 of the Communicator EXT 4 0 Software User Manual Step 3 The EIG meters are already set up for Energy logging there is nothing addi tional you need to do If you need to make any changes you use the Communicator EXT application to configure your meter s to log the values you want to use for Energy and other commodity logging The instructions for this are in Chapter 3 Step 4 Configure the EnergyReporter EXT application settings provider customer customer locations rate structures meters at location The instructions for this step are in Chapter 4 Step 5 Use the EnergyReporter Dashboard Viewer use the Usage Dashboard to compare usage data for different time frames meters dates and compared to weather data generate and view usage reports and bills The instructions for this step are in Chapter 5 Chapter 6 Manage data Cha
151. the final charge you can see the effect of the tiered rate charges in the following table Tiered Rate Added to Surcharges Monthly Bill 0 01 x 900 9 00 2 1500 0 01 x 1000 20 00 0 02 x 500 3 2500 0 01 x 1000 0 02 x 1000 0 05 x 500 h Click OK to save your settings and return to the Fixed Charges tab screen Your new charge is listed on the screen NOTES To edit a charge click on the charge in the list and click the Edit Selected Fixed Charge icon You will see the same screen as when you are adding a fixed charge but it will show the charge s settings Change what you want and click OK to save the changes To delete a charge click on the charge in the list and click the Remove Selected Fixed Charge icon You will see a Confirmation window asking if you are sure you want to remove the charge click Yes to remove click No to keep the charge i Electro Industries Gauge Tech Docs E167701 4 22 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings Rates Rates are the amount of money charged per usage commodity For instance with electricity the rate is usually an amount of cents per kWh On Peak rates often cost more than Off Peak rates If you are not using Time of Use based rates then set only one rate and amount The charge per unit is in dollars and cents so for 5 cents enter 0 05 Click the Rates tab to configure sp
152. through the meter list as described here For instructions on manually adding a meter see Section 4 4 1 10 The meters are listed in their assigned groups Click on a meter and click the Select button to add it The Edit Meter Information screen is re displayed with the selected meter s Import Location e Ss Edit Meter Information Meter Name Meter Serial Meter Type Import Location devlist 0145283023 Select Import Settings to automatically import the meter s settings from a CommExt log database Press apply to save changes Commodity Rollover cP Apply port settings from Meter log file Values Changed Selected meter s location information Click to import meter settings 11 Click the Import Settings from Meter Log File icon You will see a window telling you that the settings have been imported Click OK to close the window The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries GaugeTech Doct E167701 4 Step 4 Configure the E Billing EXT M Application Settings 12 Click the Apply icon The screen will re display showing the selected meter s information and additional icons P a T es Edit Meter Information Meter Name Office RP Selected Meter Serial 0145324524 meter S informa Meter Type Shark 200 tion Import Location devlist 0145324524 Select Import Settings to automatically import the meter s
153. ting the software re you sure you want to continue 8 Click Yes The software will shut down Open it again to display the translated appli cation Electro Industries Gauge Tech Doc E167701 7 19 The Leader In Power Monitoring and Smart Grid Solutions 7 Additional Features and Advanced Functions 7 5 Performing Tasks Using Command Line You can trigger an import of all meters or generate all bills from command line This feature is used if you wish to launch the EnergyReporter EXT application from a third party application and have it run tasks Using the command line the EnergyReporter EXT application can be embedded as a launch command into any third party applica tion 7 5 1 Import Data Using Command Line This can be useful for automating the importing of data The command you use is as follows Path A BillSettingsEditor Master exe script import meter all IMPORTANT e Path is the path to the application on your PC You must include the quotation marks For example C Program Files x86 Electro Industries EnergyReporter EXTYBillSettingsEdi tor BillSettings Editor Master exe script import meter all 7 5 2 Generate All Bills Using Command Line This can be useful for automating the generation of bills Make sure this runs after all the data for the month has been imported The command you use is as follows Path BillViewer BillViewer exe script generate b
154. tion Procedure 1 4 1 3 Connect to the Database Server 1 15 1 3 1 Specify the Database Server 1 15 1 4 Enter a Software License Key 1 16 1 5 Steps for Using the EnergyReporter EXT Application 1 18 2 Step 2 Use MeterManager EXT to Automate EnergyReporter EXT 2 1 2 1 Add Meters to the Meter List Using Auto Discovery 2 1 2 2 Manually Connect to Meter 2 6 2 3 Log Retrieval through MeterManager EXT 2 9 3 Step 3 Set Up Logging 3 1 4 Step 4 Configure the EnergyReporter EXT Application Settings 4 1 4 1 Set Up a Provider 4 4 i Electro Industries Gauge Tech Docs E167701 TOC 1 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents 4 2 Set Up Rate Structures 4 8 4 3 Set Up a Customer 4 35 4 4 Set Up a Location and Add Meters to It 4 37 4 4 1 Adding a Meter Manually 4 47 4 4 2 Meter at Location Example 4 50 4 4 3 Importing External Data 4 52 5 Step 5 EnergyReporter Dashboard Viewer 5 1 5 1 Accessing the EnergyReporter Dashboard Viewer 5 3 5 2 Usage Dashboard 5 7 5 3 Generating and Viewing Usage Reports 5 14 5 3 1 Executive Summary Usage Report 5 14 5 3 2 Generate Usage Reports 5 16 5 3 2 1 View Usage Reports 5 18 5 4 Generating and Viewing Customer Bills 5 20 5 4 1 Individual Bills 5 21 5 4 2 Generate Bills Manually 5 24 5 4 3 View Bills 5 27 6 Managing Data 6 1 6 1 View Copy Export Meter Data 6 1 6 1 1 Export Meters Data 6 5 6 2 Edit Data Errors 6 8 6 3 Re Aggregate All L
155. tomer can have multiple locations 5 Assign the meters and a rate structure to the customer s locations Each location can have multiple meters and a rate structure for each commodity being billed for e g Energy and gas 6 A meter billing point can also be an aggregate of more than one metering point this is called a virtual meter For example Meter A Meter B Meter A 50 of Meter B Meter A Meter B Meter A 50 of Meter B e Etc With virtual meters a user can configure meters to accurately represent the load by apportioning the correct amount of energy per meter for the actual circuit usage Electro Industries hauge Tech Doc E167701 4 2 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT Application Settings For example if your customer owns three apartment buildings you would set up each building as a location and enter all of the meters in a building as well as any rate structures applied to usage for that building See the diagram below N Meter 7 Customer Meter Meter Customer is the person who receives the bill Some locations may be large and have more than one measurement point Location is the physical address of what is being billed Device measuring the actual energy usage Figure 4 1 Overview of Customer Locations Meters Rate Structures Electro Industries hauge Tech Doc E167701 4 3 The Leader In
156. u are setting up this PC as both a Viewing Client and an Editing Client able to make changes to settings click both the Settings Editor and Bill Viewer boxes f you are setting up this PC as the Network database server click all three boxes i Electro Industries Gauge Tech Docs E167701 1 10 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 7 Click the check box next to the components you want and click Install You will see the screen shown below as the software is being installed Energyfeponerta4OSeup el Installing Gunite 1 Please wait while EnergyReporter Ext 4 0 is being installed ry Execute C Users ndeibler AppData Local Temp ebillingext settings editor exe 5 D C Pr rd bee SE psd O tee np Sia MullsoFE Install System v2 46 8 If you want to display the detailed actions during the installation click the Show Details button You will see a display on the lower part of the screen as files are being installed See the example screen on the next page The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries Gauge Tech Docs E167701 1 11 1 Step 1 Install the Application 33 EnergyReporter Ext 4 0 Setup Installing Please wait while EnergyReporter Ext 4 0 is being installed Execute C jUsersindeibleriAppData LocaliTemptebilingext settings editor exe 5 D C Pr Extract C sers ndeib
157. u shall indemnify and hold EIG and its authorized representatives and or resellers harmless from any claims and compen sate the same against any damages which any third party including but not limited to governmental and or international authorities and or organizations will claim against EIG and or its authorized representatives and or resellers as the result of any such violation by You or Your representative s 12 COMPLETE AGREEMENT This Agreement and any addendum or amendment included with the SOFTWARE constitutes the entire Agreement between EIG and You in relation to your use of the SOFTWARE and supersede any other previous or con temporaneous communications Agreements representations warranties or advertis ing with respect to the SOFTWARE Any change will be effective only if in writing signed by EIG and You 13 SEVERABILITY If and to the extent any provision of this Agreement is held illegal invalid or unenforceable in whole or in part under applicable law such provision or such portion thereof shall be ineffective as to the jurisdiction in which it is illegal invalid or unenforceable to the extent of its illegality invalidity or unenforceability and shall be deemed modified to the extent necessary to conform to applicable law so as to give the maximum effect to the intent of the parties The illegality invalidity or unenforceability of such provision in that jurisdiction shall not in any way affect the legality validity
158. unding lines in Red and Green 5 Comparison to previous Month and Year Displays a comparison of daily usage between this month and last month and this month this year and this month last year The daily usage is lined up by week day for each month The numbers at the bottom indicate what day in the month each bar represents The top value is the current month the bottom value the month being compared against 6 Monthly Usage and Temperature Displays a comparison of monthly usage and temperature The highest and lowest temperature for each day over the course of the month are determined and displayed as the bounding lines in Red and Green Description of Report Data i Electro Industries Gauge Tech Docs E167701 A 1 The Leader In Power Monitoring and Smart Grid Solutions EIG Engineering August 2014 Usage Summary Report Monthly Usage Summary Customer Month Date Commodity kWh EIG Engineering 08 01 2014 to 08 31 2014 A Sample Usage Summary Report Figure Meter Location Meter Name Meter Type Meter Serial Total Usage Peak Usage Peak Demand l Main Building Aggregated Meter Aggregated Meter 17731 14 57 2 Main Building 1800ShamesDr Shark 200 0123995130 17345 14 56 3 Main Building Cubicle 1 Shark 200 0145324120 71 0 0 4 Main Building Cubicle 2 Shark 200 0126370221 50 0 0 5 Main Building Cubicle 3 Shark 200 0145324019 55 0 0 6 Main Building Cubicle 4 Shark 20
159. ustomer Rates Provider All Logs Viewer Customers e e 1 E Locations E gs Building 1 Meter Specifics Meter Name Office JK Aggregated Meter Serial 0145283023 1500_ND Meter Type Shark 200 E Meters amp 1800ShamesDr amp Office DS Office JK amp Office JS 6 Office RK W hours Received E Office RM E Office RP Shark200 Unit gs Building 2 3 Meters MM Shark200T uniti Edit Imported Data Remove Meter Edit Meter Import logs now Script Status 9 p 2 From the Menu bar click Tools Database Maintenance gt Clear Meter Data 3 You will see a window that prompts you to enter DELETE See the exam ple screen on the right Type DELETE in the entry field and click OK to delete the meter data 4 You will see the message window on the right Click OK to close the message window The Leader In Power Monitoring and Smart Grid Solutions Type in DELETE to confirm the deletion of all the log data for 1272poller Electro Industries Gauge Tech Doc E167701 7 11 7 Additional Features and Advanced Functions 7 4 Option Screens Both the EnergyReporter Settings Editor and EnergyReporter Dashboard Viewer have an Options screen You access this screen by clicking Tools Options from the main screen s Menu bar The screen has four tabs for settings Paths Configuration UI and Language The settings are the same on both screens ex
160. ustries Gauge Tech Docs E167701 1 3 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 2 1 Installation Procedure 1 Insert the EnergyReporter EXT application s CD into your PC s CD drive You will see the following screen in your web browser uif E MAE LIT d Version 4 0 EnergyReporter EXT Application al EE The Lander ie Power Maclraring asd Senat Grid Selunens i Electro Industries Gauge Tech Doc E167701 1 4 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 2 Click the Software button to open the Setup Wizard screen P EnergyReporter Ext 4 0 Setup ec es Welcome to the EnergyReporter Ext 4 0 Setup Wizard This wizard will quide you through the installation of EnergyReporter Ext 4 0 It is recommended that you cose all other applications before starting Setup This will make it possible to update relevant system files without having to reboot your computer Click Next to continue Electro Industries hauge Tech Doc E167701 1 5 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 3 Close any open programs and click Next You will see the screen shown below coo 4 Soto NN me License Agreement Please review the license terms before installing EnergyReporter Ext 4 0 Press Page Down to see the rest of
161. want to view the computed interval values select this option c lt commodity gt DEMAND this is the maximum Demand for an hour period computed from the interpolated interval values for the previous hour These values cannot be changed as they are computed from the root com modity e g kWh DEMAND If you want to view the max Demand select this option i Electro Industries Gauge Tech Docs E167701 6 2 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data Start Date the start date of the data to show You can only change this field when All Timestamps and Bill Period are unchecked End Date the end date of the data to show You can only change this field when All Timestamps and Bill Period are unchecked All Timestamps select this checkbox to automatically select the entire range of stored data to show Bill Period select this checkbox to see the date range of the billing data in all available billing periods Click the pull down menu to display the date ranges When you select a date range the beginning and ending date are displayed in the Start Date and End Date fields Values to Show the checkboxes provide filters so that only the data you want to see is shown e g only Errors All Values show all the values If this is selected no other option is valid Rollover show values flagged as a rollover This occurs when the previ ous value is near the configured rollove
162. ware pack and other items including the License Key written materi als binders or other containers and hardware if any accompanying this Agreement to the place where you obtained them for a full refund INSTALLATI ON UPLOADING ACCESS OR OTHER COPYING OR USE OF THIS SOFT WARE OR ANY ACCOMPANYING DOCUMENTATION OR MATERIALS EXCEPT AS PER MITTED BY THIS AGREEMENT IS UNAUTHORIZED AND CONSTITUTES A MATERIAL BREACH OF THIS AGREEMENT AND AN INFRINGEMENT OF THE COPYRIGHT AND OTHER INTELLECTUAL PROPERTY RIGHTS IN SUCH SOFTWARE DOCUMENTATI ON AND MATERIALS YOU MAY BE LIABLE TO EIG FOR DAMAGES AND YOU MAY BE SUB JECT TO CRIMI NAL PENALTIES 1 GRANT OF LICENSE In consideration of payment of the license fee and your Agree ment to abide by the terms and conditions of this Agreement EIG grants to you the following non exclusive rights a Installation and Use You may install and use one copy of the SOFTWARE program on a single computer at a single location in accordance with the applicable User Doc umentation and within the scope of this Agreement The computer cannot have more than one copy i e session or instance of the SOFTWARE running at any one time El G s license grant and with that grant Your right to install and use the SOFTWARE and User Documentation is conditioned on Your continuous compliance with all i Electro Industries Gauge Tech Docs E167701 iii The Leader In Power Monitoring and Smart Grid Solutions li
163. y Aggregations accumulation Primary Scaled Primary MP200 Pre configured in Log 2 MP200 Y or Log 3 MP200 S See the Communicator EXT 4 0 and MeterManager EXT Software User Manual for detailed instructions Electro Industries Gauge Tech Doc E167701 3 4 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Configure the E Billing EXT M Application Settings 4 Step 4 Configure the EnergyReporter EXT Application Settings Use the EnergyReporter Settings Editor to set up the information you need to gener ate usage data bills and usage reports When you start the EnergyReporter Settings Editor you see the main screen ges fester O Dele File Configure Tools Help o 8 Lj mi Add Edit Edit Import Dashboard Customer Rates Provider All Logs Viewer Automated Energy Reporting Icons for setting 3 1 Cost Analysis and Usage Billing up provider Locations customer rate o Bi Building 1 structure 3 Meters importing all E Aggregated Meter det dpe in the MAIN MENU 6 5 MO pm EnergyReporter rere bo e m mu Dashboard Office Ds Viewer are in 2 amp Office JK Edit Rate Structures Dashboard Viewer pla ces oe Edit or Modify billing Rate al Launch the Dashboard Viewer Office Js eS Structures G Office RK Edit Provider Office RM EM ete Office RP Customers Shark200 Units locations Bs Building 2 and meters 3 Meters are shown M Shark200T unit 7 he
164. you want to delete WARNING Be careful when deleting across multiple locations as it is easy to select more bills than you intend or miss some you want to delete NOTE Removing a customer or location from the system doesn t delete the bills that have already been generated for them If you want to get rid of the bills you must delete them manually Electro Industries Gauge Tech Doc E167701 5 28 The Leader In Power Monitoring and Smart Grid Solutions 6 Managing Data 6 1 View Copy Export Meter Data 6 Managing Data The EnergyReporter EXT application gives you access to the usage data in a variety of ways You can view the data copy it export it and correct any errors in the meter data Follow these steps to view copy or export the imported meter data 1 From the EnergyReporter Settings Editor main screen use the Tree menu on the left of the screen to navigate to the meter you want See the example screen below E EnergyReporter EXT Settings Editor File Configure Tools Help edi m 4 EY la Add Edit Edit Import Dashboard Customer Rates Provider All Logs Viewer A Customers c e 1 E Locations g Es Building 1 tj Meters Aggregated Meter 1500_NJD amp 1800ShamesDr Office Ds _ Office JK Office JS Channel lb Office RK W hours Received Click on meter Office JK 0145283023 Shark 200 2 Click the Edit Imported Data icon Electro Industries Gaug

EnergyReporter EXT User Manual V.1.03

Contents

Download Pdf Manuals

Related Search

Related Contents