Home

E-Billing EXT Application User Manual V.1.02

1. 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Monthly Usage at a Glance Customer College Park Apartments Month Date 9 1 2013 to 9 30 2013 Commodity kWh Building 4 1800ShamesDr 1 Building 6 1700ShameDr 2 7 gt 00 s00 A A 5 600 5 600 500 D ta ta 5 5 s 400 400 300 200 1 Sun 8 Sun 15 Sun 22 Sun 1 Sun 8 Sun 15 Sun 22 Sun Sep 2013 Sep 2013 BBH Holdings 200 Middletown Road Altoona PA 16601 Page 4 of 14 Electro Industries Gaugefech Doc EF167701 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 768 Building 4 1800ShamesDr Total Usage during Peak Day e on oO aa p ise z gt N o oD iss Nn I foe ee N is 3 O pu jes O N College Park Apartments Wednesday September 11 2013 Total Usage Peak Usage Figure 1 3 15 f s x i a i 12 Thu a D 6PM 3PM 12PM 9AM 6AM 3AM BBH Holdings 200 Middletown Road Altoona PA 16601 Page 7 of 14 8 15 Doc E167701 Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions jies Electro Industr 7 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Building 4 1800ShamesDr Average Hourly and Daily Usage Displays the average usage over the course of
2. v Last refreshed at 5 25 2012 3 31 14 PM R C Electro Industries Gauge Tech Doc E167701 6 3 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 2 Select Create Basic Task You will see the screen shown below 1 Create a Basic Task Create a Basic Task Use this wizard to quickly schedule a common task For more advanced options Trigger or settings such as multiple task actions or triggers use the Create Task command f in the Actions pane Action _ _ oe Name Finish Description 3 Give the task a name e g Import All Logs and click Next You will see the screen shown below E eee Create Basic Task Wizard gt 1 Task Trigger Create a Basic Task When do you want the task to start Daily Action a Weekly Finish Monthly One time When the computer starts When I log on When a specific event is logged Electro Industries Gaugefech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 4 Select the interval you want the data to be imported and click Next Create Basic Task Wizard l x Daily Create a Basic Task Trigger Recurevery 1 days Action Finish Start 8 2 2012 lx 8 00 00AM Synchronize across time zones 5 Enter the time you want the import to take place The example screen is set up for a
3. e Data Point the channel of the data to view There are typically three values for each commodity a lt commodity gt 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 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 C Electro Industries Gauge Tech Doc E167701 6 9 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data modity e g KkWh DEMAND If you want to view the max Demand select this option e Start Date the start date of the data to show You can only change this field when All Timestamps and Bill Period are unchecked e End Date the end date of the data to show You can only change this field when All Timestamps
4. g a Database Maintainance Archive Databases Restore Databases Clear Databases Server Status You have three options e Restart click this button to start the local database server after it has been shut down e 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 Click OK to proceed with the shutdown NOTE The local database server does not close when you exit the E Bill ing 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 C Electro Industries Gauge Tech Doc E167701 9 10 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 6 Clear Meter Data The E Billing 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 E Billing Settings Editor Location screen highlight the meter whose data you want to clear See the example screen below r E Billing Settings Editor File Configure Tools Help DEBUG Test Add Edit Edit Impor
5. Trending Log Frofile Log 2 1 ME Group Sub Group Stored in log as Scaled Primary a Selectable temis l Selected termis Quadrant 1 4 Vvh i al Interval Energy Scaled Quadrant 1 4 wh Quadrant 2 3 Wh Quadrant 1 2 VARA Quadrant 3 4 VARA Quadrant 1 2 35 4 VA Quadrant 1 vv h Quadrant 2 vv h Quadrant 3 vv h Quadrant d h Quadrant VARA Quadrant 2 VARA Quadrant 3 YARA Quadrant 4 VARA Quadrant 1 Ash Quadrant 2 WAR Quadrant 3 WAR Quadrant 4 Ah h idh Total bytes used 2 Estimated Log Timespan Bytes remaining edd Total Records Electro Industries Gauge Tech Doc El167701 2 5 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging For the Shark 200 200S meters we recommend the settings shown in the screen below for logging Energy in the Interval Shark 200 The Meter Designation is Not Configured V Switch 6 Offline File Tools View Help a po Settings CT PT Ratios and System Hookup 7 Time Settings System Settings a Communications i Display Configuration g Revenue amp Energy Settings h Power Quality and Alarm Settings S Trending Profiles Historical Log Profile 1 Historical Log Profile 2 Historical Log Profile 3 Historical Log Sectors h Option Card 1 h Option Card 2 Historical Log Profile 1 Group Energy in the Interval Selectable Items Watt hours recerved Wratt hours delivered AA hou
6. _ Ener Interval Commodit Ener Interval Commodit gy Energy y gy Energy y Shark Energy Energy in the Accumulators Watt hours Watt hours Input used Interval Received Received for accumulation Interval Internal Pulse Quadrant Quadrant Input used Nexus Accumulators Energy Scaled Accumulators Accumulation 1 4 Wh 1 4 Wh for Energy Aggregations accumulation Scaled Primary Primary MP200 Pre configured in Log 2 MP200 Y or Log 3 MP200 S Electro Industries Gauge Tech Doc F167701 2 11 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging This page intentionally left blank Electro Industries Gauge Tech Doc F167701 2 12 The Leader In Power Monitoring and Smart Grid Solutions 3 Step 3 Initial Download of Meter Logs 3 Step 3 Initial Download of Meter Logs Perform an initial download of the meter s logs to get the basic log data from the Communicator EXT application into the E Billing EXT Database server 1 From the Communicator EXT main screen s Title bar click either Logs gt Retrieve Log s from Device or the Retrieve Logs icon You will see a screen similar to the one shown below different meters have slightly different screens but they all allow you to select logs for download Log Statistics for Nexus_1500_N_0000000047380527 Newest Record Time Oldest Record Time Record Size Max Re
7. set and the Log Converter will prepare the data and send it to the log database The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 4 9 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application This page intentionally left blank Electro Industries Gauge Tech Doc F167701 4 10 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 5 Step 5 Configure the E Billing EXT Application Settings The E Billing Settings Editor lets you set up the information you need to generate bills When you start the E Billing Settings Editor you will see the main screen shown below r E Billin Settings Editor g File Configure Tools Help FU mE m Add Edit Edit Import Dashboard EXT Customer Rates Provider AllLogs Viewer Automated Energy Reporting a amp 11567 Cost Analysis and Usage Billing B Locations f Mathers Building Welcome to the trial version of E Billing Ext Click Upgrade License to enter a new license Meters Provider Email Settings not configured 90000010 Nexus_ 1500 Add Customer ee ee Shark_poller party who will receive the bill iad og g amp 12457 Locations 9 Edit Rate Structures Launch Bill Viewer a amp 14577 l Locations Edit Provider a Upgrade License a amp 14678 Loca
8. Digital 1 0 Interval Energy Watt hours Received Mete3 Log data is fixed for C h an g ed Interval Energy Watt hours Received Mete3 Interval Energy Watt hours Received Mete3 the stated values Interval Energy Watt hours Received Meter4 Interval Energy Watt hours Received Meter4 Interval Energy Watt hours Received Meter4 Interval Energy Watt hours Received Meter Interval Energy Watt hours Received Meter Interval Energy Watt hours Received Meter5 Make sure the Logging nterval is 15 minutes a Logging Interval Minutes Time Available 89 days 6 hours 58 minutes aan a 6 For all meters except the MP200 use the pull down menu s at the top of the screen to display the available logging values The values are listed in the box on the left e For the Nexus 1252 1262 1272 1500 meters for logging Energy we recommend you select Accumulators for Group Energy for Sub Group and Scaled Primary for Stored in Log As use the pull down menus for logging Energy in the Interval we recommend you select Interval Accumulators for Group Energy for Sub Group and Scaled Primary for Stored in Log As e For the Shark 200 200S meters for logging Energy we recommend you select Energy for Group use the pull down menu for logging Energy in the Interval we recommend you select Energy in the Interval for Group 7 To select an Energy value for trending not applicable to MP200 whose logging
9. Log downloader az Any scripts already created are in the pull down menu C Electro Industries GaugeTech Doc E167701 4 3 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 3 Click New You will see the screen shown below Setup Script Script Name Log downloader Connection Type Ethernet Number of Retries 2 E Start Log Converter after this script is finished Script Connection Properties IP Address or Name pees 4 You will create a script for each meter whose data you are downloading unless some of your meters are slaves to a Master meter in which case they can be entered in the same script as the Master instructions for this are given in step 8 Enter the following data e Script Name give this script a unique name It is best to call it the name or location of the meter e Connection Type select Ethernet from the pull down menu e Number of Retries this field specifies whether you want the application to try connecting for the programmed number of times between 0 and 5 if the first attempt was unsuccessful Since this setting applies to Modem communication primarily you should leave the default setting of 0 e Start Log Converter after this script is finished is the default and cannot be changed Log Converter is a related application that takes the data downloaded from the meter
10. P a6 E Billing Dashboard Viewer File Reports Tools Help 7 Generate View Bills Usage Dashboard All Bills Customers Location Information a gy 11567 amp Locations B Mathers Building Artanis Sates View Monthly Data Cust ID 12457 5 gy 12457 lt g 1 Click ona oe 3 eae customer Location Name Building 4 S Monthly Utility Bill E Locations Address 400 Wopsononock Road A Alt PA 16601 fF Building 4 i A Exedutive Summary Usage BE Building Next Bill Date 11 1 2013 P Repdrt RP gt cli k Rates Electricity 2 a Je 14577 Cli n wet lt gt C a Meters 1 Usage Dashboard Locations location Bill Data Range 5 26 2013 9 28 2013 a gy 14678 Locations a a 17850 Previous Month Views Click Monthly Bill 9 1 2013 Bill Generated 11 1 2013 Utility Bill a Usage Report 9 1 2013 v Report not generac Locations a amp 29087 Locations a gy 34567 Locations 7 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 Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Step 7
11. s log files and converts the data into the correct type of database for later retrieval This is done automatically within the software you do not need to do anything e Script Connection properties enter the meter s IP address and the TCP IP Ethernet port your PC uses to connect to it the default port is 502 Ci Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 5 Click Devices You will see the screen shown below ag Devices for Script Up to 256 devices x at Device ID Device Address Device Type 6 Click Add You will see the screen shown below F Edit Script Device Script Connection type Ethernet Connection type for this device Ethernet lt User Security Settings Type Nexus 1500 v Device Name Device Information Administrator Password Data Switch Strings o 4y iA 7 This is where you add the information for the meter whose log you want to down load Device Name enter the name of the meter e Archive Options click to view and or change options for archiving the log database files e Device Information enter for your meter device address e g 1 select Modbus TCP for communication protocol and select your meter s type e g Shark 200 Electro Industries Gauge Tech Doc F1
12. Bill Viewer exe script generate_ bill Electro Industries Gaugefech Doc EF167701 9 15 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions This page intentionally left blank Electro Industries Gauge Tech Doc F167701 9 16 The Leader In Power Monitoring and Smart Grid Solutions Glossary lt pg_data gt For Windows XP For Windows 7 lt pg_ exe gt E Billing Settings Editor Bill Structure E Billing Dashboard Viewer Billing Database Channel Charge Electro Industries Gaugefech The Leader In Power Monitoring and Smart Grid Solutions Glossary The data directory for the PostGreSql database cluster for the E Billing Ext application This is the lt Common Application Data gt Electro Indus tries 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 PostGreSq Data base Server executable This is typically lt Program Files gt Electro ndustries Server Post GreSQL 8 4 The E Billing Ext software for administering the Billing Package including location configuration data import rate configuration and modifying data values Another name for Rate Structure The E Billing
13. 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 vill 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 RESTRICTIONS You may physically transfer the SOFTWARE from one com puter to another provided that the SOFTWARE is used on only one computer at a time in conjunction wi
14. click OK 8 While the database is being restored you will 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 E Billing EXT application Electro Industries Gaugelech Doc F167701 9 8 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 5 Additional Database Options The Database Maintenance screen has two additional options e Clear Databases click this tab to display the screen shown below r a Database Maintainance gt O a Archive Databases Restore Databases Clear Databases Server Status Warning This will delete all imported data and all configured settings All changes data and bills will be lost Delete Databases i WARNING Make very sure that you want to delete all of the data in the data base 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 Electro Industries Gaugelech Doc F 167701 9 9 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions e Server Status click this tab to display the screen shown below
15. or enforceability of such provision in any other jurisdiction or affect the legality validity or enforceability of any other provision of this Agreement 13 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 14 AUDITS To ensure compliance with this Agreement You agree that upon reason able notice EIG or EIG 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 1 You are liable to pay for any unpaid license fees as well as the reasonable costs of the 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 immediately Any information obtained by EIG or EIG s authorized representative dur ing the course of such inspection and audit
16. 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 data on the database server Using this to restore to a server will overwrite all data WARNI NGS e 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 To begin archiving open E Billing Settings Editor and click Tools gt Database Maintenance gt Maintenance Utilities from the main screen s Title bar You will see the screen shown below displaying a warning message r a Database Maintainance m Archive Databases Restore Databases Clear Databases Server Status Warning Many of the tools on the page can change or even destroy data stored on the database server Are you sure you want to continue Browse Begin Archiving Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 2 If you are sure yo
17. 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 GE September 2013 EE September 2012 kwh usage per Day fm i m UW BBH Holdings 200 Middletown Road Altoona PA 16601 Page 14 of 14 C Electro Industries Gauge Tech Doc E167701 8 22 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 Additional Features and Advanced Functions 9 1 Viewing the Action Log The E Billing EXT application has a log in which actions such as importing generating bills updating data and sending emails are stored You can view this log through the Action Log Viewer which is available from the E Billing Settings Editor In addition errors can be viewed and corrected from the Action Log Viewer 1 From the E Billing Settings Editor click Tools gt View Action Log See the example screen below Action Log Viewer x Fl View By Date Time H E Show All Actions Date Time gt TE Customer ID 1234 Import 11 1 2013 10 58 AM 1234 at Buildin _ O are Location ID Building 4 Import 11 9 2013 10 58 AM 1234 at Buildin Report 11 1 2013 11 02 AM 1234 at Building Report 11 1 2013 11 02 AM 1234 at Building Report 11 1 2013 11 10 AM 1234 amn 4 4 9072 49 45 DMA 734 at Build Description Importing log for 1600ShamDr from C Report 11 1 2013 12 15 PM 1234 at Build eu 2 BS Users nd Desktop Framemaker E Repor
18. A Monthly Utility Bill Address 400 Wopsononock Road Altoona PA 16601 Executive Summary Usage Next Bill Date 11 4 2013 eport Rates Electricity 2 Meters 1 Usage Dashboard Bill Data Range 5 26 2013 9 26 2013 Click this icon 2 You will see the window shown below Use it to select the data you want to see in your report This feature lets you generate a customized report with only the data Doc E167701 8 5 g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 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 Report Customer Housing International Location House 1 Date August 2013 Report Type E Generate for all customer locations Report Options O Display Demand Reports to include Report Overview Monthly Usage Summary Highest Usage Meter Comparison Usage At a Glance Meter Total Usage during Month Meter Total Usage during Peak Week Meter Total Usage during Peak Day Meter Average Hourly and Daily Usage 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 If you want to see deman
19. Accumulator 4b cl ick Add Opt Card 2 Output 2 4ccumulatar 4b Opt Card 2 Output 3 4ccurnulatar 4b Log Record Logging Interval Minutes js Total bytes used Time Available 213 days 5 hours 30 minutes Bytes remaining Save Profile Load Profile ee ey The MP200 meter s Log 2 and Log 3 are pre configured for commodity logging 9 The E Billing EXT application uses 15 minute intervals make sure the log s Interval is 15 minutes For the Nexus meters click the Set Interval button to open a Logging Interval window for the Shark meters and MP200 metering sys tem select the Interval from the pull down menu at the bottom of the Log Profile screen Note that the energy interval Demand Averaging interval must also be 15 minutes 10 When you are done click OK to close the window You can repeat this procedure to set up additional logs 11 From the Device Profile screen click Update Device to send the new profile to the meter NOTE If you already set up logs for this meter or changed other settings updating the Device Profile will reset all of the logs The application gives you a chance to retrieve the logs before they are reset C Electro Industries Gauge Tech Doc E167701 2 10 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging Table of Settings for Logging Energy Energy in the Interval and Commodity Group Sub group Data Point
20. Billing EXT application in Network mode Through Windows Task Scheduler You can also use the Windows Task Scheduler to set up automatic import Use this method if you are running the application in Local Only mode NOTE The following instructions are for Windows 7 OS for Windows XP OS you access Task Scheduler by clicking Start gt All Programs gt Accessories gt System Tools gt Scheduled Tasks for Windows Vista OS you access Task Scheduler by clicking Start gt Control Panel gt System and Maintenance gt Administrative Tools gt Schedule Tasks 1 Start Windows Task Scheduler by clicking Start gt All Programs gt Accessories gt System Tools gt Task Scheduler You will see the screen shown below Task Scheduler File Action View Help e gt 0 H Task Scheduler Local RES Sae EE A EEE ESE I Task Scheduler Libra Overview of Task Scheduler m D You can use Task Scheduler to create and manage common tasks that your computer will carry out automatically at the times you specify To hanin elinle nm anmannan in Status of Last 24 hours v Summary 0 total 0 running 0 suc Connect to Another Computer Create Basic Task Create Task iaa gt WI Import Task Ea Display All Running Tasks Enable All Tasks History AT Service Account Configurat View gt Refresh Help
21. By default all periods which have no errors and haven t been generated before 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 C Electro Industries Gauge Tech Doc E167701 7 4 The Leader In Power Monitoring and Smart Grid Solutions 7 Step 7 Generate Bills 7 1 2 Generate All Bills for Customers Location Since the Generate All Bills option can take a long time to complete the E Billing EXT application gives you two additional options for generating a smaller number of bills Access these options from the Reports gt Generate Bills submenu from the E BIill ing Dashboard Viewer main screen s Title bar The submenu is shown below View Bills View Usage Reports Generate Bills Gene
22. College Park Apartments September 2013 This report provides a summary of the kWh usage for College Park Apartments from Sunday September 01 2013 to Monday September 30 2013 This report was generated on Thursday November 07 2013 Meter Report Each meter report contains 5 sub reports 1 Month Usage Summarizes the usage of the meter over the course of September 2013 from 9 1 2013 12 00 00 AM to 9 30 2013 11 59 00 PM 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 usage of the meter over the course of the peak week during September 2013 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 Usag
23. E am Ea a Aeq Jad aBesn yA afiesn UAAy JO puas anulu G Po So S o W 7 G College Park Apartments September 2013 Usage Summary Report Building 6 1700ShameDr 8 Step 8 Usage Dashboard and Reports Total Usage during Peak Week 9 8 2013 to 9 14 2013 Total Usage 5784 Peak Usage 16 Kwh usage per Day 15 minute trend of KWh usage 8 Sun 9 Mon 10 Tue Sep 2013 o eae og OM e Why NY 11 Wed 12 Thu BBH Holdings 200 Middletown Road Altoona PA 16601 Electro Industries Gaugefech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 13 Fri Figure 2 2 fw Ct oe 14 Sat Page 11 of 14 8 Step 8 Usage Dashboard and Reports Building 6 1700ShameDr Total Usage during Peak Day e a o aa N oO oN iss Nn I lag q N Pat oO Oo O j gt 2a o N Thursday September 12 2013 Total Usage College Park Apartments Peak Usage Figure 2 3 PA 16601 BBH Holdings 200 Middletown Road Altoona Page 12 of 14 20 Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions Electro Industries Gaugefech 7 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Building 6 1700ShameDr Average Hourly and Daily Usage Displays the average usage
24. Ext software for generating bills viewing bills and trending the data values The internal storage on the database 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 E Billing 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 PostGreSql 8 4 The package of software which includes E Billing Settings Editor E Billing 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
25. Generate Bills from being generated Help ge Dashboard 7 T Pd Location Information ng oF cto Spodic View Monthly Data Customer ID 12457 Location Name Building 6 View bill errors Address 602 Juniata Gap Road Alttona PA 16601 ae E Executive Summary Usage as Next Bill Date 11 1 2013 mal Renart View Bill Errors icon 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 e Errors can only be corrected from the E Billing Settings Editor e Typically the errors in DEMAND and INTERPOLATE INTERVAL 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 i The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 7 7 7 Step 7 Generate Bills 4 Once the bill is generated it opens in your screen See the example bill below Total Summary Elect
26. Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 17 Click Close You will return to the Script amp Scheduler main screen Under the Scheduler column at the bottom of the screen click Add Script You will see the screen shown below Scheduler Available Scripts for Scheduler so04 Download logs shark 200 schedule Frequency Hour Minute Cancel 18 Select your new script from the pull down menu select Interval for Frequency and specify 12 hours and O minutes This will cause a download of the meter s logs every 12 hours NOTE This is not the only setting you can make but it is the recommended setting when you are scheduling automatic import of meter data through the E Billing EXT application You can perform the downloads more often but we do not recommend that you perform them less often 19 Click OK You will return to the Script amp Scheduler main screen Add additional scripts as needed for downloading logs from additional meters NOTE You can enter 300 scripts If you have more than 300 meters you will need to set up an additional server and run the Script amp Scheduler application on it to add the additional meters 20 When you are done re start the Script amp Scheduler application by clicking the Run Stop button Your log data will now be retrieved according to the interval you
27. Meter Data Follow these steps to view the imported meter data 1 From the E Billing 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 r E Billing Settings Editor File Configure Tools Help s B E Add Edit Edit Import Dashboard Customer Rates Provider AllLogs Viewer Customers al s a amp 11567 Meter Information amp Locations S Mathers Building E Meters 0000000020375017 Meter Specifics rockt Main CPU s Edit Imported Data 0116557025 20000010 MP200 Main _CPU Remove Meter Nexus_1500 Poller Shark_poller Channel Type Click on meter Click this icon Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 6 8 6 Step 6 Importing Data 2 Click the Edit Imported Data icon You will see the Search Bill Data screen shown below Data Search All Values tart Date Wednesday October 23 2013 E All Errors E Zero Counters End Date Wednesday October 23 2013 Rollover All Timestamps E Increasing Too Fast Bill Period E Wobbly Value E Decreasing Counter E Good Values 3 This screen lets you choose which data point channel date range and type of values you want to view e Meter from the pull down menu select the meter whose data you want to view Only meters at the currently selected location are shown
28. Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 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 If no rollover is programmed in the HMI EXT application the E Billing EXT application rollover value should be the same as the rollover value in the meter s device profile set in the Communicator EXT application in the meter s Device Profile gt Revenue and Energy Settings gt Energy Scaling Energy Scale Settings Pulte Accumulations and Aggregatians and Y Squared T Readings Uncompensated Energy Decimal Places Units Example gya i 39999 99 39999 99 O Hours Test Mode Energy Energy Quadrant 1 4 h Quadrant 2 3 Veh Net Wh uses Quadrant 1 4 wh settings Global Settings The Rollover Value is this number 1 Electro Industries Gaugefech Doc F167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings This page intentionally left blank Electro Industries Gauge Tech Doc F167701 5 44 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 6 Step 6 Importing Data 6 1 I mport Meter Data Before the E Billing EXT application can generate bills the meters log databas
29. Option card with a 2 card maximum per meter Electro Industries Gaugetech Doc E 167701 2 09 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging For the Shark 200 meter we recommend the settings shown in the screen below for logging commodities other than Energy E C Shark 200 The Meter Designation is Not Configured V Switch 6 Offline bs E General Settings CT PT Ratios and System Hookup Historical Log Profile 1 gt Time Settings i System Settings Group X Communications ao are S e ect fro i L Display Configuration pu ll down H Revenue amp Energy Settings E Power Quality and Alarm Settings Selectable ltem s Selected ltem s menus i Trending Frofiles Input Accurulator 4b Historical Log Profile 1 Opt Card 1 Input 2 Accumulator 4b i Historical Log Profile 2 Opt Card 1 Input 3 Accumulator 4b BK Add xy 3 Historical Log Profile 3 Opt Card 1 Input 4 Accurulator 4b N P Opt Card 1 Output 1 Accurnulatar 4b 5 Historical Log Sectors Opt Card 1 Cutput 2 Accumulator4b S elect the n put H Uption Card 1 Opt Card 1 Output 3 Accumulator 4b th at IS reco rd in g W Option Card 2 Opt Card 1 Output 4 Accurulator 4b Soest Opt Card amp Input 1 Accurulator 4b the com mod Ity S Opt Card 2 Input 2 Accumulator 4b Opt Card 2 Input 3 Accumulator4b p u Ise m ete r an d Opt Card 2 Input 4 Accumulator 4b Opt Card 2 Output 1
30. Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc EF167701 5 33 5 Step 5 Configure the E Billing EXT Application Settings 5 Click Apply to create the location The screen changes to offer more options now you can add meters and rate structures See the example screen shown below Edit Location Information Location Name Building 500 Bill Period Ist of the month Location Address 500 College Park Drive Altoona PA 16601 Rate Structure Add a Meter to this Location Add Rate Structure Meters Edit Rate Structure Remove Rate Structure Remove this Location Values Saved 6 The new options let you Add a meter to this location e Add a rate structure to this location e Edit a rate structure for this location e 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 new location these boxes will be empty but if you are editing an existing location there will be entries in the boxes Electro Industries Gaugelech Doc F167701 5 34 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings When you set up a location you add all of the meters at the location and add one rate structure for each commodity being billed
31. Settings i System Settings Group i Display Configuration h Revenue amp Energy Settings g Power Quality and Alarm Settings ERNE 8 Trending Profiles Walt a erie att hours Received Historical Log Profile 1 Watt hours Delivered i Historical Log Profile 2 watt hours Net Historical Log Profile 3 Watt hours Total Historical Log Sectors VAR hours VAR hours VAR hours Net d Option Card 1 E Option Card 2 VAR hours Total 4 hours Total Watt hours Received Watt hours B Received Watt hours C Received Watt hours Delivered Watt hours B Delivered Watt hours C Delivered Geof aott Iw kiok A SS Historical Log Profile 2 Selected Item s Energy Watt pours Received Box on left and click Add Log Record Total bytes used Logging Interval Minutes 255 days 21 hours 0 minutes Bytes remaining Time Available NOTES Select from pull down menu e The MP200 metering system has Energy in the Interval logging but not Energy logging e The logging interval must be 15 minutes and the energy interval Demand Averaging interval must also be 15 minutes Electro Industries Gaugefech l The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 2 Step 2 Set Up Communicator EXT Logging Energy in the Interval Logging Settings For the Nexus 1252 1262 1272 1500 meters we recommend the settings shown below for logging Energy in the Interval
32. 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 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 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 and or Off Peak usage The Peak Demand rate you enter will be applied to peak demand in the selected rate periods when the bill is gen erated i e the Peak Demand usage Is multiplied by the Peak Demand rate to get the Peak Demand charge C Electro Industries Gauge Tech Doc E167701 5 27 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e If you select Coincidental Peak Demand enter a Name and Rate for the Coincidental Peak Demand and then choose the Utility meter from the pull down menu Fixed Charges Charge Type Coincidental Peak Demand Coincidental Peak Demand Name Coincidental Peak Demand Coincidental Peak Demand 0 00 Rate Coincidental Utility Meter ees A Coincidental Peak Demand Charge is a charge applied against the Peak Demand over the period of the bill where the Peak
33. are adding a rate but it will show the rate s settings Change what you want and click OK to save the changes e 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 assigned to the next available rate 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 generate 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 C Electro Industries Gauge Tech Doc E167701 5 20 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings Season 1 weekends is charged the Off Peak rate You will see the screen shown below 5 Rate Structure Name Commodity z Number of Seasons Two Seasons v Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Weekday Season One Weekend S
34. are as follows Seasons Setting The Seasons setting lets you set up different rates for up to four different times of the year referred to as Seasons 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 Peak 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 Weekdays Weekends 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 Electro Industries Gauge Tech Doc F167701 5 11 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings Holidays The E Billing EXT application configures holidays based on a perpetual calen dar 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 Click the Holidays tab You will see the screen shown below r Rate Structure Name Commodity Number of Seasons Two Seasons v Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar 2 Add new Holiday Janua
35. correct log 13 Note that the Primary Command is Retrieve and the Secondary Commands are a a selection of logs a Click the logs that you set up with the billing data see Section 1 5 1 b The blank field at the bottom of the screen tells the Script amp Scheduler application where to find the logs it needs to download If you want to use the Communicator EXT application s default location keep this field blank If you want to set a new location for the retrieved logs click Browse to locate it By default for the Windows XP OS the retrieved logs are stored in C Documents and Settings user My Documents Electro I ndustries Communicator EXT Retrieved Logs For the Windows 7 OS the retrieved logs are stored in C Users Public Documents Electro ndustries Communicator_EXT Retrieved Logs For the Nexus 1500 meter only the path includes after Retrieved Logs meter s name_meter s serial num ber logs log_type logtype db 14 Click OK You will return to the Commands for Script screen The command you entered and the device it is for are displayed on the screen If you entered slave meters repeat the process for all of the meters in the Device pull down menu 15 Click Close You will return to the Setup Script screen 16 Click Close You will return to the Create New Open Delete Script screen Your script will be in the pull down menu C Electro Industries Gauge Tech Doc El167701 4 8 The
36. daily import at 8 a m Click Next You will see the screen shown below r Create Basic Task Wizard Action Create a Basic Task Trigger What action do you want the task to perform Daily Finish Send an e mail Display a message j Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 6 Select the Start a Program radio button for the Action and click Next You will see the screen shown below r Create Basic Task Wizard Start a Program Create a Basic Task Trigger Program script Da pene Add arguments optional ies Start in optional Finish 7 Do the following a For the Program Script browse to the install location for the E Billing Ext soft ware and select the BillSettingsEditor Masterexe program For example C Program Files x86 Electro Industries E Billing EXT BillSettingsEditor Bill SettingsEditor Master exe NOTE You must use quotation marks as shown above b Enter Script import meter all in the Add arguments field c Leave the Start in field blank d Click Next 8 Click Finish j Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 9 The import will occur at the specified time under the current user Keep in mind the computer must be on and the user logged in
37. down Until then the software remains running even though all the windows are closed 6 1 3 Import Customer s Locations This option lets you import the data for all of the meters for a customer This can Speed up the import if you are only interested in importing any new data for one customer From the E Billing Settings Editor main screen click on the customer you want in the list and then click Tools gt I mport gt Import Customer s Locations The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 6 7 6 Step 6 Importing Data 6 1 4 I mport Meter If there is new data for just one meter you can import just that by selecting the meter and clicking the Import Logs Now icon See the partial screen capture below FU E Add Edit Edit Import Dashboard l PEELING Customer Rates Provider AllLogs Viewer Customers E a amp 11567 Meter Information Meter Specifics amp Locations amp a Mathers Building E Meters i Main CPU Edit Imported Data 0116557025 MP200 0000000020375017 WW 90000010 Main_CPU Nexus_ 1500 e Edit Meter T Import logs now Click this icon Poller Shark_poller Channel Type Click on meter NOTE If you need to re import old data hold down the Ctrl gt Shift keys while clicking the Import Logs Now icon doing this will wipe out data already imported 6 1 5 View
38. 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 usage during the billing period see step c e 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 e 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 e 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 pages 5 17 5 18 C Electro Industries Gauge Tech Doc E167701 5 15 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings c For every charge type except Peak Demand and Coincidental Peak Demand you then enter the Charge Name and Rate or Percentage for Tax If you select Peak Demand the screen changes as shown below Fixed Charges Charge Type Peak Demand g Peak Demand Name Peak Demand Peak Demand Rate Apply To E Holiday O Off Peak E On Peak A Peak Demand Charge is a charge applied against the ag
39. file is scanned when imported and new data is placed into the billing database A single unit for which 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 Doc 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 Doc E167701 Glossary GL 4
40. for the import to run To config ure the computer to automatically turn on run under a different user or run no matter what user is logged in or to configure more complex scenarios consult the Task Scheduler Help for details 6 1 2 Import All You can also perform a manual importing of data The simplest way to manually import the meter data is with the Import All Logs button which is located in the E Billing Settings Editor main screen s Title bar After you click this button the soft ware checks every configured meter s Import location for new data and queues it to be imported If there is no data to be imported for a meter the meter is not added to the queue It is important that you perform a manual import at least once to verify you have set everything up correctly An import screen appears on your PC during the import process It displays the list of meters which are to be imported and the status of the current import If any import fails it is flagged in red and a list of the errors is displayed on completion When an import is completed successfully it will display done and disappear from the list At any time you can click Abort to cancel the import This will stop the importing of all the queued items except for the current one which will run to completion If you close the software before importing is done the import is aborted and once the current import is complete the software fully close
41. is preset click on it in the box and click Add to move it to the box on the right e For the Nexus 1252 1262 1272 1500 meters we recommend you select for both Energy and Energy in the Interval logging Quadrant 1 4 Wh Electro Industries Gaugetech Doc E 167701 2 7 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging e For the Shark 200 200S meters we recommend you select for both Energy and Energy in the Interval logging Watt hours Received NOTE To remove an item you don t want to log from the box on the right click on the Item and then click the Remove button 8 To log values for commodities other than Energy for example gas or steam not applicable to MP200 whose logging is preset e For the Nexus 1252 1262 1272 1500 meters select Internal Pulse Accumula tions for Group and Aggregations for Sub Group from the pull down menu Then select whichever Input is recording accumulations from the pulse meter measuring the gas or steam e For the Shark 200 200S meters select Accumulators for Group from the pull down menu Then select whichever Input is recording accumulations from the pulse meter measuring the gas or steam Refer to the following diagram and screens Measured Steam Pulses are counted by meter Meter s Digital Meter with Outputs Pulse Output Pulses Input Figure 2 1 Example of How the Meter Measures Non Ene
42. 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 r O U gt Computer OS C gt Users Public Public Documents Electro Industries Communicator_Ext gt Retrieved Logs gt Organize v Include in library v Share with v Burn New folder J Links Name Date modified Type m My Backup Files E My Documents d Electro Industries J E Billing Ext GE145751_dsgn di MAGIX Downloads W MAGIX_Screenshare a SightSpeed Recordings d Snagit J Dina_Paintings 4 Errans Pics E FW_Fonts_and_logo 4 Neena Deibler pics J pics 10 16 2011 m My Music My Pictures BB My Videos B Saved Games i Searches B Virtual Machines jE Computer amp 05 C amp DVD RW Drive D BuffyScreenSaver Danrameabhla Miel 0 J 14 items NOTES J Backup Logs 6 1 20128 51 AM File folder J CSVRECS 2 27 2012 5 44PM File folder J HHF Files 4 12 2012 10 17 AM_ File folder Ji log_archive 4 12 2012 10 17 AM File folder M Nexus _1500_N_0000000047380527 012 9 16 AM File folder 1272_IP73 3 1 2012 1 48 PM Data Base File 54 418 KB __ 1272_1P73 EBM DB 9 22 2010 2 16PM EBM DB File 96 KB 1272_IP73 3 1 2012 1 43 PM Configuration sett 1 KB la INTERVAL 1 6 4 2012 10 02AM Data Base File 1 460 KB nexus_1500_n 2 6 1 20128 52AM Data Base File 914 KB Nexus_1500_N 6 1 2012 8 52 AM Data Base File 914 KB Select a file _ Nexus_1500
43. of Meter Logs 3 1 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 4 1 4 1 Setting Up the Log Download Scripts 4 3 5 Step 5 Configure the E Billing EXT Application Settings 5 1 5 1 Set Up a Provider 5 3 5 2 Set Up Rate Structures 5 6 5 3 Set Up a Customer 5 31 5 4 Set Up a Location and Add Meters to It 5 32 I Electro Industries Gaugefech Doc E167701 TOC 1 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents 5 4 1 Meter at Location Example 5 40 5 4 2 Importing External Data 5 42 6 Step 6 Importing Data 6 1 6 1 Import Meter Data 6 1 6 1 1 Automatic Data Import 6 1 6 1 2 Import All 6 7 6 1 3 Import Customer s Locations 6 7 6 1 4 Import Meter 6 8 6 1 5 View Meter Data 6 8 6 1 6 Export Meter Data 6 12 6 1 7 Correct Data Errors 6 14 7 Step 7 Generate Bills 7 1 7 1 Generate Bills Manually 7 2 7 1 1 Generate All Bills 7 3 7 1 2 Generate All Bills for Customers Location 7 5 7 2 Individual Bills 7 6 7 3 View Bills 7 9 8 Step 8 Usage Dashboard and Reports 8 1 8 1 Usage Dashboard 8 1 8 2 Usage Reports 8 5 8 2 1 Executive Summary Usage Report 8 5 8 2 2 Generate Usage Reports 8 7 8 2 3 View Usage Reports 8 9 I Electro Industries Gaugefech Doc t EF167701 TOC 2 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Functions 9 1 Viewing the Action Log 9 2 Best Practice
44. only one historical log for use with the E Billing 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 Energy Logging Settings For the Nexus 1252 1262 1272 1500 meters we recommend the settings shown below for Energy logging Select from pull down menus Trending Log Profile Log 1 Group Sub Group CE Wt SCS RLE aT EERE Scaled Primary i Selectable Item s Add gt gt Quadrant 1 4 Wh it s Energy Scaled Quadrant 1 4 Wh Quadrant 2 3 Wh Quadrant 1 2 VARh Quadrant 3 4 VARh Quadrant 1 2 3 4 VAh Quadrant 1 Wh Quadrant 2 Wh Quadrant 3 Wh Quadrant 4 Wh Quadrant 1 VARh Quadrant 2 VARh Quadrant 3 VARh Select from Box on left and click Add Quadrant 3 VAh Quadrant 4 VAh Qh Qh Total bytes used 12 Estimated Log Timespan 648days 12hour 45min Osec Bytes remaining 244 Total Records 62259 C Electro Industries Gauge Tech Doc E167701 i gt Ss The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging For the Shark 200 200S meters we recommend the settings shown in the screen below for Energy logging P Shark200 Shark200Unit1 Serial Number 0090769536 V Switch 6 E General Settings CT PT Ratios and System Hookup i Time
45. 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 I Electro Industries Gaugefech Doc E167701 iv vi Modifications You may not modify translate adapt arrange or create derivative works based on the SOFTWARE for any purpose vil 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 or other means designed to circumvent or remove the License Manager
46. sent with bills and usage reports e New automated data importing and report generation for the Network version of the application e You can now select up to four seasons and can name the seasons e You can now view an Action log which helps you locate and address errors 1 2 Install the E Billing EXT Application E Billing EXT software can be run either as a standalone program the databases 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 See your System Administrator for the setup you will be using NOTE You must also have the Communicator EXT application installed on your PC The E Billing EXT application must be run on a computer with one of the following operating systems e Windows XP Operating System e Windows Vista Operating System e Windows 7 Operating System e Windows 8 Operating System C Electro Industries Gauge Tech Doc El167701 1 2 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 2 1 Installation Procedure 1 Insert the E Billing EXT application s CD into your PC s CD drive You will see the following screen in your web browser Manual Software Version 3 0 E BILLING EXT APPLICATION Electro Industries GaugeTech The Leader in Power Monitoring and Smart Grid Solutions 2 Click the Software button
47. should be click this button to have the software enter 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 e 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 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 C Electro Industries Gauge Tech Doc E167701 6 16 7 Step 7 Generate Bills 7 Step 7 Generate Bills You use the E Billing EXT application s E Billing Dashboard Viewer to generate and view bills as well as for viewing usage data in the usage dashboard and generating and viewing Executive Summary Usage Reports both of which are explained in the next chapte
48. the Seasons Seasons 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 Electro Industries Gaugefech Doc EF167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings Rate Calendar Rate Structure Name Electricity 2 Commodity kWh X lumber of Seasons Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Rate Calendar Monthly Rates October 2013 10 10 2013 Daily Rates Thursday October 10 2013 Season One Sun Mon Tue Wed Thu Fri Sat 00 00 06 00 12 00 18 00 00 00 Legend Rates Holiday E Rate Charge per unit Season One Off Peak 0 025 Off Peak E On Peak 0 035 E On Peak Season Two E Off Peak E On Peak 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 do not need this information continue to step 8 The Leader In Power Monitoring and Smart Grid Solutions g Electro Industries GaugeTech Doc E167701 5 Step 5 Configure the E Billing EX
49. 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 EIG 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 I Electro Industries Gaugefech Doc E167701 Vi The Leader In Power Monitoring and Smart Grid Solutio
50. to open the Setup Wizard screen See the screen below 9 E Billing Ext 3 0 3 0 Setup Welcome to the E Billing Ext 3 0 3 0 Setup Wizard This wizard will guide you through the installation of E Billing Ext 3 0 3 0 Itis 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 g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 1 3 1 Step 1 Install the Application 3 Close any open programs and click Next You will see the screen shown below E Billing Ext 3 0 3 0 Setup License Agreement Please review the license terms before installing E Billing Ext 3 0 3 0 Press Page Down to see the rest of the agreement This legal document is an agreement between you as the end user of E BILLING EXT software SOFTWARE and Electro Industries GaugeTech EIG By making a copy T of or using the SOFTWARE you agree to be bound by the terms of this agreement IF YOU DO NOT ACCEPT THE TERMS OF THIS AGREEMENT YOU MUST NOT USE THE ISOFTWARE If you have acquired a physical software pack do not openit Promptly return the unopened software pack and other items induding the License Key written materials binders or other containers and hardware if any accompanying this Jagreement to the place where you obtain
51. 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 e 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 Specific Day and click the pull down menu to open a calendar that lets you choose the day of the holiday that only occurs once e Click the radio button next to Special Days to select a holiday that doesn t follow any of the above rules such as Easter Electro Industries Gaugelech Doc F167701 5 13 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings d Click OK to save the holiday and return to the Holidays tab screen NOTES e 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 e 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 re
52. 047380527 Meter Type 0154 Nexus 1500 C Users Public Documents Electro Industnes Communicator_ Ext Retreved Logs Nexu Select Import Settings to automatically import the meters settings from a CommeExt log database Import Location Commodity Rollover ihe SE Import settings from Meter log file Scaled Energy Q14Wh 100000000 k j Add Channel Edit Channel Remove Channel Remove this Meter 14 The Channel icons let you add edit or remove channels A channel is a single type of data item from the meter s log database e g Watt hours Received You add the channel and link it to a commodity for use in generating bills e g the Watt hours Received channel linked to the kWh commodity Click Add Channel You will see the screen shown below Select the meter log channel to use for the commodity Meter Channel Commodity Rollover unscaled O Auto adjust Rollover Percentage of usage applied 100 to bill Adds or subtracts a of the meters usage to the g Electro Industries GaugeTech Doc EF167701 5 38 i The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 15 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 application They are channels for Energy and or pulse accumulations See Section 5 4 2 for channel setting instructions for exte
53. 167701 9 5 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 6 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 9 4 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 1 From the E Billing Settings Editor main screen s Title bar click Tools gt Database Maintenance gt Maintenance Utilities Electro Industries Gaugelech Doc F167701 9 6 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 2 Click the Restore Databases tab You will see the screen shown below r o ad Database Maintainance E js Archive Databases Restore Databases Clear Databases Server
54. 67701 A 5 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application e Security settings and password if security settings and or password protection is used for the meter enter those values in the appropriate fields e Data switch strings leave these fields blank 8 Click Update You will return to the Devices for Script screen NOTE You can repeat steps 6 and 7 to add more meters to the script if you are entering slave meters i e meters connected to a Master device Slave meters share the Master meter s connection IP address but they must have unique device addresses You can add up 256 meters in total 9 When you finish entering devices click Close You return to the Setup Script screen 10 Click Commands You will see the screen shown below E Commands for script Up to 5000 commands Command Description Electro Industries Gauge Tech Doc E167701 4 6 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 11 Click Add You will see the screen shown below Add Script Command Primary Commands Secondary Commands E System data switch string Pi iS D000 System Device z Number of Retries o i Send switch string z Name Sting 12 Select your meter from the Device pull down menu The screen chan
55. 701 ic The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 9 Click OK You will see the screen shown below G E Billing Ext 3 0 3 0 Setup Completing the E Billing Ext 3 0 3 0 Setup Wizard E Billing Ext 3 0 3 0 has been installed on your computer Click Finish te dose this wizard Cancel 10 Click Finish to close the Setup Wizard 11 To run the application select it from the Start menu See the example screens below Microsoft Office Outlook 2003 J Adobe J Adobe LiveCycle ES2 p PEEN re ER J Adobe Master Collection CS5 Core FTP FM Adobe FrameMaker 10 Dell Dell DataSafe wi Microsoft Office Word 2003 Dell DataSafe Online Dell Stage Microsoft Office Excel 2003 Dell Support Center Dropbox Ps Adobe Photoshop CS5 64 Bit Electro Industries mn Automatic Export to Excel o iiatlla aati Communicator Ext Manual A Communicator Ext Automatic Export to Excel SE Converter Activity Logs TAi Adobe Illustrator CS5 Data Files Log Viewer a Notepad Nexus Script amp Scheduler J E Billing Ext E E Billing Ext Settings Editor E Billing Ext Settings Editor g6 E Billing Ext Viewer 3 Uninstall E Billing Ext Settings Ed 3 Uninstall E Billing Ext Viewer v The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 1 8 1 Step 1 Install the Application 1 3 Connect
56. Demand is computed on the configured Utility Meter rather then the aggregation of the meters at the location d Click OK to save your settings and return to the Fixed Rate screen Your new charge is listed on the screen NOTES e 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 e 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 7 Click Store to save your Flat Rate rate structure Cj Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT 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 NOTES e 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 ra
57. Doc E167701 5 3 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e Click Configure next to the Email Server Settings Provider Email Server Settings Email Settings From accountsrec bbh com Send copy of emails to provider Host Settings Host mail bbh com 25 User accountsrec bbh com Password cael Send Settings Retries Retry Timeout ms Set to 0 to disable The settings on this screen are used for automatically sending bills and energy summary reports to different users The software will automati cally send out these emails reports 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 C Electro Industries Gauge Tech Doc E167701 5 4 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e Click Configure next to the Email Report Settings fie
58. E BILLING EXT Enterprise Level Automated Energy and Commodity Reporting and Billing Software Application 17 Shames Drive iM23520617 Total Usage duri pan 2013 bio BP hey Pekan O z o O _ T 2 V Installation amp Operation Manual V 1 02 November 4 2013 T Electro Industries Gaugetech The Leader In Power Monitoring and Smart Grid Solutions 1800 Shames Drive Westbury NY 11590 Tel 516 334 0870 Fax 516 338 4741 Email sales electroind com This page intentionally left blank E Billing EXT Installation and Operation Manual Version 1 02 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 2013 Electro Industries GaugeTech Nexus and Shark are registered trademarks of Electro Industries GaugeTech The distinctive shapes styles and overall appearances of the Nexus 1500 meter and the Shark meters are trademarks of Electro Industries GaugeTech E Billing EXT HMI EXT and Communicator EXT are trademarks of Electro Industries GaugeTech Microsoft Excel
59. Shark 200 and 200S meters the MP200 metering system and all Nexus series meters The E Billing EXT application performs complex calculations such as multiple entity aggregation and supports user programmable 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 electri cal billing It also supports detailed usage analysis in the form of uSage reports and trending charts The E Billing EXT application has three parts e E Billing Settings Editor the part of the application you use to set up billing includ ing customer and location configuration data import rate configuration and cor recting errors in the imported data e E Billing Dashboard Viewer the part of the application you use to view the Energy Dashboard generate and view bills view and analyze usage data and generate and view usage reports e Database Server the part of the application which provides access to the billing database New to this version of E Billing EXT software are the following e Support for the MP 200 metering system e Support for Interval Energy e Flat Rate Only rate structure added Electro Industries Gaugefech Doc t EF167701 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application e Updated screens e Dashboard Viewer for usage data analysis e Emails can be
60. Status This restores an entire archived database cluster This will delete the current contents and restore it to a previously saved database Select a file or path and click Begin If the restore fails try restarting the server and restore again Archive Location Use single file archive 3 Click Browse to locate the database archive you want to restore 4 If the archive was stored in a single file leave the checkbox selected If it was stored in multiple files uncheck the box 5 Click Begin Restore to restore the r Restore Databases database You will see the message window shown on the ri g ht Restoring database clusters require deleting the old contents and inserting old data Are you sure you want to continue 6 Click Yes to continue You will see gt Close Confirmation the message window shown on the ri g ht i 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 C Electro Industries Gauge Tech Doc E167701 9 7 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 7 Click Yes to continue You will see the x Message window shown on the right Type in RESTORE to confirm the restoration of all of the databases Key RESTORE in the blank field and
61. T Application Settings 6 To set up a rate structure with a single rate only no On Peak Off Peak Seasons Weekend Weekday or Holiday rates select Flat Rate from the Add Rate Structure pull down menu Add Rate Structure Flease choose the type of rate structure to add You will see a screen similar to the Flat Rate tab of the Seasonal Schedule r Rate Structure Name Commodity X Fixed Charges N ao Add Fixed Charge Edit selected Fixed Charge gt Remove selected Fixed o Charge Flat Rate Flat Rate Electro Industries Gaugefech Doc EF167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings a Enter a Name for the Flat Rate select the Commodity it will be applied to from the pull down menu and click Add Fixed Charge to enter the rate Fixed Charges Charge Type i Fixed Charge Name Fixed Charge Rate Fixed Charges are a single monitary value which is applied to a whole bill regardless of the energy used This will typically be things like penalties taxes and credits b Select the Charge Type from the pull down menu You can select Fixed Peak Demand Flat Rate Tax or Coincidental Peak Demand 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 ePeak Demand sel
62. T application database file formatted for use with the E Billing EXT application HIME KWHR CONDENSATE 1 1 2012 0 00 AM 433 6 25536607 1 1 2012 0 15AM 438 0 25530607 1 1 2012 0 30AM 442 5 25530606 1 1 2012 0 45AM 446 9 25530606 1 1 2012 1 00AM 451 4 25530605 1 1 2012 1 15AM 455 8 25536605 e The database file must have four fields e DATE the date of the record formatted as yyyy mm dd e 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 E Billing EXT application see Section 5 4 for instructions This field is assumed to be in kilo scale e The optimal interval for the data is 15 minutes time stamped on the minute e 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 E Billing EXT application e The file name should be eight characters with an extension of three characters e g Nx1500_ 2 dbf NOTES e HMI EXT databases separate the original meter from the data so there is no way for the application to determine the rollover value Consult the HMI Electro Industries Gaugetech Doc F167701 5 42 The Leader In Power
63. Users ndeibleDocuments Electro Industri PgTools Path C Program Files x86 Electro Industries E Bil Default Archive Pat E Billing Settings Editor Options Screen E Billing Dashboard Viewer Options Screen 9 6 1 Path Setting E Billing Dashboard Viewer setting e Default Bill Definition this is the template for the bills Click Browse to set up another location E Billing 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 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 g Electro Industries GaugeTech Doc EF167701 9 12 i The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 7 2 Configuration Setting The settings are the same for both the E Billing Dashboard Viewer and the E Billing Settings Editor This setting controls what options are available to the user 1 Click the Configuration tab You will see the screen shown below m Options Paths Configuration UI Configuration Type Basic Advanced 2 Click the radio button of the option you want to set e Basic restricts access to functional billing ta
64. _N EBM DB 6 1 20128 51AM EBM DB File 96 KB Sp Nexus_1500_N 8 6 2012 11 54 AM Configuration sett 1 KB _ Retrieved Logs 12 7 2010 5 12 PM Text Document 0 KB e The log database file comes from either the Communicator EXT application db the database created when logs are retrieved using the Communicator EXT application or the HMI EXT application dbf the billing data database created by the HMI EXT software see that software s documentation for details e See Section 9 1 for file importing suggestions WARNINGS e Be careful when selecting the location to import from Importing is done by the E Billing Settings Editor software and if you select a location that is not accessible or invalid you may not be able to import the data e If 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 Electro Industries Gaugetech Doc F167701 5 36 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 10 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 11 Once you ve selected the file to import from the application will verify that it contains log items that can be linked
65. 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 EIG products are primarily designed manufactured tested and calibrated at our facil ity in Westbury New York Cj Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions License Agreement for the E Billing EXT Software Application This legal document is an Agreement between you as the end user of E Billing 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 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 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 software pack and other items including the License Key
66. and Bill Period are unchecked e All Timestamps select this checkbox to automatically select the entire range of stored data to show e 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 e Values to Show the checkboxes provide filters so that only the data you want to see is shown e g only Errors e All Values show all the values If this is selected no other option is valid e Rollover show values flagged as a rollover This occurs when the previ ous value is near the configured rollover 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 e 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 e Good Values show values which are not flagged with an error con
67. and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and or other countries Software version 3 0 Cj Electro Industries GaugeTech Doc 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 I ndustries GaugeTech Founded in 1975 by engineer and inventor Dr Samuel Kagan Electro ndustries 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 certified company EIG sets the industry standard for
68. any time click Reports gt View Usage Reports See the example screen shown below ps Usage Reports J Save Report View Report Options 1234 kWh May 2013 1234 kWh June 2013 1234 kWh July 2013 1234 kWh August 2013 1234 kWh September 2013 1234 kWh October 2013 May 2013 June 2013 July 2013 August 2013 September 2013 October 2013 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 reports beginning on page 8 11 If the report hasn t been generated yet for the month it is generated when you select it 3 You can also e Click the Options icon to 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 8 2 1 step 4 e 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 C Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 8 10 8 Step 8 Usage Dashboard and Reports NOTE The following Usage report is an example only College Park Apartments September 2013 Usage Summary Report Usage Summary Report for
69. ation Step 7 Use the Generate All Bills command to generate bills for all of your locations The instructions for this step are in Chapter 7 Step 8 Use the imported data to generate usage reports and trending The instruc tions for this step are in Chapter 8 Chapter 9 View the Action log and learn additional tips and advanced options Electro Industries Gaugetech Doc F167701 1 12 The Leader In Power Monitoring and Smart Grid Solutions 2 Step 2 Set Up Communicator EXT Logging 2 Step 2 Set Up Communicator EXT Logging You set up Energy Energy in the Interval and other Commodity logging in the meter s Device Profile NOTE The basic steps are given here For more detailed information consult the Communicator EXT User Manual you can access the manual online by clicking Help gt Contents in the Communicator EXT Title Bar F A Communicator Ext l r File Connection Real Time Poll Tools MO Devices TOU Calendar Logs View Hep ab D n n 2 yn m Bore profile SMieve openlog connect connect dise polling energy THD Check for Software Updates Software License Gre us Feedback Purchase a new Meter About Communicator Ext 1 Open the Communicator EXT application by clicking Start gt All Programs gt Electro Industries gt Communicator EXT You will see the screen shown above 2 Click the Connect icon in the Title bar to connect to the meter you are setting up See the exampl
70. ck the components you don t want to install Click Install to start the installation Select components to install oe Bill Viewer pate Database Server Automation Server Space required 59 6MB This screen lets you choose the application components you will install on the PC Electro Industries Gaugetech Doc F167701 1 6 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application e If you are setting up this PC as a Client the billing data will be stored on a Network database server on a different PC check only the Bill Viewer box e If you are setting up this PC as a Network database server check all four boxes e If you are setting up the PC in standalone mode the application and database server will both be on the PC check the first three boxes NOTE You can also install any of the individual components by itself but the settings explained above are the recommended settings 7 Click the radio button next to the setting you want and click Install You will see the screen shown below as the software Is being installed E Billing Ext 3 0 3 0 Setup Installing Please wait while E Billing Ext 3 0 3 0 is being installed Execute C Wsers nd AppData Local Temp ebillingext settings editor exe S O C Pr Show details 8 At one point during the installation you will see the following message window Install Successful C Electro Industries Gauge Tech Doc E167
71. cords Log Memory Used Memory k Select Historical 2 P ij utes 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 16 32767 1024 Historical 2 1 Weir 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 32 26214 1024 Historical 3 1 TEA 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 112 88939 10240 Historical 4 1 MEA 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 32 311296 10240 1 MEA 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 116 95870 10240 If Historical 6 1 Meiers 09 03 2012 13 45 00 00 08 03 2012 13 45 00 00 28 355765 10240 Historical 7 1 MSA 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 46 216552 10240 A 08 03 2012 13 45 00 00 08 03 2012 13 45 00 00 38 262143 10240 Mery 00 00 0000 00 00 00 00 00 00 0000 00 00 00 00 32 31129 1024 Mery 00 00 0000 00 00 00 00 00 00 0000 00 00 00 00 64 15564 1024 A 00 00 0000 00 00 00 00 00 00 0000 00 00 00 00 32 31129 1024 A 00 00 0000 00 00 00 00 00 00 0000 00 00 00 00 96 10375 1024 META 08 03 2012 13 40 01 22 08 03 2012 13 40 01 22 40 24903 1024 AASA 08 03 2012 13 32 10 92 08 03 2012 13 32 10 92 614512 38 40960 MA 08 03 2012 13 32 11 09 08 03 2012 13 32 11 09 572 34827 20480 1481 MAEA 08 03 2012 13 32 11 45 03 25 2010 17 24 19 57 16 32767 1024 Transients 0 widens 00 00 0000 00 00 00 00 00 00 0000 00 00 00 00 25984 380 10240 EN50160 7 IEC 61000 4 30 Yes AEA Not Applicable Not pplicable Not pplicable Not Applicable Not Applicab LJ Polling Flicker Header To retriev
72. d 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 The report will be similar to the example report Shown on pages 8 11 8 22 except that it will only contain the locations and data you selected C Electro Industries Gauge Tech Doc E167701 8 6 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 8 2 2 Generate Usage Reports Click Reports in the E Billing Dashboard Viewer main screen s Title bar You will see the submenu shown below View Bills View Usage Reports Generate Bills Generate Usage Reports The View Bills and Generate Bills options have already been explained in Chapter 7 There are two additional Report options Generate Usage Reports and View Usage Reports 1 Click Reports gt Generate Usage Reports gt Generate Customer Report You will see the screen shown below Select what usage reports to generate Customer Start of Month Channel Month May 2013 June 2013 July 2013 August 2013 September 2013 October 2013 2 Select the customer start date for the month and channel The Month box fills with the ava
73. dition 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 5 Electro Industries GaugeTech Doc F167701 6 10 i The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data in Green Values which are errors and will prevent a bill from being generated are Shown in Red See the example screen below r go Bill Data for 11567 Mathers Building Nexus_1500 kWh c x 6 x Error Code Error Desc Modified Value Modified Date 6 1 2012 6 45 AM 6 1 2012 7 00 AM 716 48 6 1 2012 7 15AM 716 48 6 1 2012 7 30AM 716 48 6 1 2012 7 45AM 716 48 6 1 2012 8 00 AM_ 716 48 6 1 2012 8 15 AM 716 48 6 1 2012 8 30 AM 716 48 6 1 2012 8 45AM 716 48 6 1 2012 9 00 AM 716 48 6 1 2012 9 15AM 716 48 6 1 2012 9 30AM 716 48 6 1 2012 9 45AM 716 48 6 1 2012 10 00 AM 716 48 6 1 2012 10 15 AM 716 48 6 1 2012 10 30 AM 716 48 6 1 2012 10 45 AM 716 48 0 00 6 1 2012 11 00 AM 716 48 6 1 2012 11 15 AM 716 48 6 1 2012 11 30 AM 716 48 CIAINNAND 44 AR AMA 74c AO slololololololololololololololoicolololo amp 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 E Billing Settings Editor and the E Billing Dashboard Vie
74. dustries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 8 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 E Billing EXT application from a third party application and have it run tasks Using the command line the E Billing EXT applica tion can be embedded as a launch command into any third party application 9 8 1 I mport Data Using Command Line This can be useful for automating the importing of data The command you use is as follows Path BillSettingsEditor Master exe script import meter all I MPORTANT 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 Industries E Billing EXT BillSettingsEditor Bill Settings Editor Master exe script import meter all 9 8 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 BillViewen BillViewer exe script generate_bill 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 Industries E Billing EXT BillViewer
75. e E Billing Settings Editor main screen You will see the message window shown below Automation disabled OK Click OK to close the window The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc El167701 6 1 6 Step 6 Importing Data To enable Auto Import again click Tools gt I mport gt Enable Auto Import from the E Billing Settings Editor main screen You will see the message window shown below Automation Enabled k Click OK to close the window NOTE e If there is an error and auto import is not running the application ties to connect to the automation service You will see the screen shown below Script Controller E Unable to connectto service Starting service up User Account Control a Windows Operating system service will start and you will be asked to enable the automation service Once you select Yes the service Should be connected to and started Auto import will be enabled If the application cannot connect to the automation service e g if you are running C Electro Industries Gauge Tech Doc E167701 6 2 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data the application in Local Only mode you will see the message shown below Script Controller E Failed to connectto automation service after starting it Verify that it has been installed correctly Confirm that you are running the E
76. e 256x128 pixels in size If it is not it is scaled by the application which may result in the image not looking the way you want 3 Click Store to save your entries and then click Exit to close the screen 5 2 Set Up Rate Structures The next step is creating rate structures that will be applied to billed usage at locations You can set up one rate structure for each commodity at a location Multiple locations can use the same rate structure 1 From the E Billing Settings Editor main screen click the Edit Rate Structures icon You will see the screen shown below Configure Rate Structures Rate Structures Electricity Add new Rate Structure Edit the selected Rate Structure Remove the selected Rate Structure Edit Commodities Locations that use this rate Customer Location Building 4 Building 6 Doc E167701 5 6 g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 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 You will see the screen shown below Add Rate Structure Please choose the type of rate structure to add Rate Structure Type Seasonal Schedule 3 Select Seasonal Schedule or Flat Rate from the pull down menu and click OK e Select Seasonal Schedule to set up a rate struct
77. e Tech Doc E167701 8 11 The Leader In Power Monitoring and Smart Grid Solutions College Park Apartments September 2013 Usage Summary Report Monthly Usage Summary Customer Month Date Commodity kWh College Park Apartments 9 1 2013 to 9 30 2013 8 Step 8 Usage Dashboard and Reports Figure Meter Location Meter Name Meter Type Meter Serial Total Usage Peak Usage Peak Demand l Building 4 1800ShamesDr Shark 200 0123995130 9891 15 60 2 Building 6 1700ShameDr Shark 200 0123320617 20354 16 65 BBH Holdings 200 Middletown Road Altoona PA 16601 Page 2 of 14 Monthly Summary Showing Total and Peak Usage For Each Meter at Each Location of the Customer g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Highest Usage Meter Comparison Customer College Park Apartments Commodity kWh Highest Usage Meter Building 6 1700ShameDr 20354 Lowest Usage Meter Building 4 1800ShamesDr 9891 Total Usage by Meters Total KWh Usage 10000 11000 12000 13000 14000 15000 16000 17000 Building 6 1 700ShameDr Meters Building 4 1600ShamesDr BBH Holdings 200 Middletown Road Altoona PA 16601 Electro Industries Gauge lech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 Page 3 of 14
78. e a log click on the checkbox in the Selected column of log s that r you want to retrieve Next click the Start Button to begin the retrieval Retrieve Selected Logs y Close Historical 8 1 Event Triggered 0 Sequence of Events Limits 0 Digital Inputs 0 Digital Outputs 0 Flicker 1 Waveform 1 Power Quality 1 OO ROOD OO 0O 0 0 0 0 0 0 0 0 2 Click the checkbox for the log you set up for Energy commodity logging and click the Start button 3 You will see messages as the log is being downloaded 4 Repeat this process for additional meters Once the process is done you can close the Communicator EXT application This is important to do for each meter you configure because it initially sets up the database so that the user will be able to attach it to the E Billing EXT application and allows you to verify that the logs were configured correctly C Electro Industries Gauge Tech Doc E167701 3 1 The Leader In Power Monitoring and Smart Grid Solutions 3 Step 3 Initial Download of Meter Logs This page intentionally left blank Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 3 2 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application The diagram b
79. e files must be imported During the import the application scans the files for new data and imports it into the database cluster which is the collection of databases the E Billing EXT Database Server provides access to While scanning the files and importing the application also analyzes the data for errors and computes interval and Demand values for example highest Energy use for a selected time period WARNING mporting uses the Import location you set up for the meter Because the import is done by the software this location must be accessible to the software doing the import If it is not Such as a network drive that is disconnected or a location that was configured on another computer the import for that meter will fail Once data has been imported you can modify it to correct for problems in the data instructions for this are given in Section 6 1 7 This will automatically cause the computed values Interval and Demand to be regenerated Keep in mind however that the changes are recorded and that any bill which contains modified values is marked to indicate that fact 6 1 1 Automatic Data I mport Through E Billing EXT Application Only Available for Network Mode If you are running the application from a Network server data import is automatically enabled Auto import occurs every hour If you are changing settings and want to Suspend auto import for a time click Tools gt Import gt Disable Auto Import from th
80. e 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 September 2013 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 bounding 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 Example Usage Report First Page C Electro Industries Gaug
81. e screen below Senal Port Oo Network Enter Device Device Address Address Host 174 22 172 154 Enter Device s IP Address Network Port Protocol Modbus TCP The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries GaugeTech Doc E167701 2 1 2 Step 2 Set Up Communicator EXT Logging 3 From the Communicator EXT main screen click the Profile icon The Device Profile screen for the meter opens See the example screens shown below C J Nexus 1500 V Switch 3 Log 2 Log 3 Log 4 Log 5 Log 6 Log Log amp Event Triggered Log External I O Modules Nexus 1500 Meter Device Profile C Shark200 test Serial Number 0045912728 V Switch 6 File Tools View Help amp General Settings lt CT PT Ratios and System Hookup Time Settings System Settings lt Communications lt Display Configuration H Revenue amp Energy Settings Power Quality and Alarm Settings H Trending Profiles Option Card 1 amp Comm a Network Option Card 2 Digital O Relay Output and Digital Input CT PT Ratios and System Hookup CT Numerator Primary CT Denominator Secondary CT Multiplier Current Full Scale PT Numerator Primary lt Update PT Update Ratio gt PT Denominator Secondary PT Multiplier Voltage Full Scale System Wiring Note To configure the CT amp PT settings either enter the Numerator Denominator and Mu
82. e usage dashboard let you perform the following tasks e Click Hide Meters to close the meter boxes and make the chart larger Click Meters to restore the meter boxes e Click Copy to copy the data to the clipboard You can then paste it into another application e g a spreadsheet Electro Industries Gaugefech Doc F167701 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports e Click Print to print the data e Export the data click Export then import the data into another application e g a spreadsheet e Click Break Out to open the data in a separate window 8 To exit the usage dashboard click the Location Info icon 8 2 Usage Reports There are two kinds of reports available from the E Billing EXT application the Executive Summary Usage Report which is a customized report containing the loca tion and data you specify and the standard usage report for all customer locations containing extensive detailed usage information Both types of reports contain useful information for usage analysis and planning 8 2 1 Executive Summary Usage Report 1 From the E Billing Dashboard Viewer s Location Information screen see screen example on the bottom of page 8 1 click the Executive Summary Usage Report icon on the right side of the screen Location Information Location Specifics View Monthly Data Customer ID 12457 Location Name Building 4
83. eason One Weekday Season Two Weekend Season Two Select a rate group to edit it s assigned rates g Electro Industries GaugeTech Doc E167701 5 21 i The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 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 orree Name cna el Right click in this box to Number of Seasons display a menu allowing multiple selections Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar Weekend On Peak Weekday Season One 02 30 E Weekend Season One 02 45 F a Weekday Season Two 03 00 E Weekend Season Two 03 15 aw 03 30 Fi m 03 45 2 Fa E 04 00 04 15 Fi a Select a rate group to edit it s assigned rates 04 15 04 30 y 04 30 04 45 7 m 04 45 05 00 W 05 00 05 15 Fj 05 15 05 30 Fj 05 30 05 45 7 E NR AR ACAN E a 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 e You can right click in the box on the right and select Set all rate times to either Off Peak or On Peak e You can select multiple time ranges by clicking on the first rate time you want to change
84. ect this to enter a Peak Demand surcharge which is an additional charge applied to Peak highest amount usage during the billing period see step c e 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 e 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 e Coincidental Peak Demand select this to enter a charge that will be 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 See pages 5 17 5 18 for a detailed explanation of Coincidental Peak Demand C Electro Industries Gauge Tech Doc E167701 5 26 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings c For every charge type except Peak Demand and Coincidental Peak Demand you then enter the Charge Name and Rate or Percentage for Tax e If you select Peak Demand the screen changes as shown below Fixed Changes Charge Type Peak Demand Peak Demand Name Peak Demand Peak Demand Rate 0 00 Apply To E Holiday O Off Peak O On Peak Off Peak E On Peak A Peak Demand Charge is a charge applied
85. ed them for a full refund If you are proposing to download the SOFTWARE or a License Key do not do so If you accept the terms of the agreement dick I Agree to continue You must accept the agreement to install E Billing Ext 3 0 3 0 Nullsoft Install System v2 46 4 This is the license agreement for the E Billing EXT application Use the scroll bars or Page Down on your keyboard to view the entire agreement If you cannot agree to the terms of the license click Cancel to stop the installation Otherwise click Agree You will see the screen shown below E Billing Ext 3 0 3 0 Setup Db Type Select Page License Agreement Please review the license terms before installing E Billing Ext 3 0 3 0 Select the type of database to install Local Only 5 Network Server 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 E Billing Settings Editor E Billing Dashboard Viewer is run Additionally the database server is only accessible from the local C Electro Industries Gauge Tech Doc E167701 1 4 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 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 t
86. elow depicts the entire automated log download and import data process for the E Billing EXT application Internal Logged Data in Meter Retrieve the Logs From the Meter Script amp Scheduler Application Configure Script amp Scheduler Application to retrieve logs from the meter e e e e we ww we ww ww ww ww ww ww ww ww ww ww ww wm wm wm em mw mw em em d Store the log data locally y Stored Log Data on PC Import the log data for use by the E Billing software E Billing EXT Database Server By default when auto import is configured in the E Billing EXT software data is imported every day at Midnight Configure E Billing EXT Settings Editor to import and analyze the log data Script amp Scheduler Application should be configured to retrieve the logs more often then this such as every 12 hours Figure 4 1 Automated Log Download and Data Import Electro Industries Gaugetfech Doc F167701 4 1 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application NOTE Automatic import is only available if you are running the software with a Net work server If you are running it in standalone mode you must use Windows Task Manager to automate data import see Chapter 6 for instructions As shown in the diagram the Communicator EXT applica
87. emove selected Commodity special 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 g Electro Industries GaugeTech Doc EF167701 i The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 5 3 Set Up a Customer Next you set up customer information The customer is the person who will be receiv ing the bill from the provider The customer can have one location or multiple loca tions The software will generate a bill for each location for this customer 1 From the E Billing 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 Edit Customer Information Customer ID 1234 Customer Name College Park Apartments Address 200 College Park Drive Altoona PA 16601 Telephone 709 943 2709 Email Email Address cpa gmail com Report Email Settings Bill Report Disabled Default Configure Usage Repot Disabled Default FEJ Add Location to this Customer Remove this Customer 2 Enter the following e Customer ID enter a unique identifier for the customer which will be used to identify this custome
88. estion Decreasing values most often occur because of time changes If this is 1800ShamesDr 6 10 2013 5 45 PM __ Interval value decreasing but ni the case clear the error to continue if this is not the case determine if the source data is correct before continuing 1800ShamesDr 6 10 2013 6 00 PM Counter values decreasing for r lt m k Filter Scan Commit Suggested action 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 Doc E167701 6 15 C Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data e The middle right of the screen contains fields you use to handle the error New Value 0 4 Use the fields 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 I nterpolate see infor mation below e 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 e Interpolate if you don t know what the value
89. for Add a Meter 7 Click the Add a Meter to this Location icon You will see the screen shown below Edit Meter Information Meter Name Meter Serial Meter Type Import Location Select Import Settings to automatically import the meters settings from a CommeExt log database Press apply to save changes Channel P Apply Foo N eho Import settings from Meter log file d 8 Enter the following e 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 e Meter Serial enter the meter s serial number e Meter Type enter the meter type Nexus or Shark 9 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 E Billing EXT application imports in order to generate its billing database i e Energy usage or pulse C Electro Industries Gauge Tech Doc E167701 5 35 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 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 E Billing EXT application use Click Browse to locate the
90. ges as shown in the examples below r Add Script Command Device D001 Nexus 1500 1 Device_1 i Number of Retries o Primary Commands Retrieve v Secondary Commands ea E Select Ei Historical Log 1 Historical Log 2 Historical Log 3 Historical Log 4 5 Historical Log 5 6 Historical Log 6 Historical Log 7 8 Historical Log 8 9 Event Triggered 10 Limit Log Foo ooo es Cd log file location override Leave blank to use the Communicator Ext one Nexus 1500 Add Script Command C Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions r Add Script Command Device D001 Shark 200 1 Shark logger zi Number of Retries o i Primary Commands Retrieve v Secondary Commands Name Select BM Historical Log 1 Historical Log 2 Historical Log 3 Limit Log 5 System Event Log 6 1 0 Change Log Waveform PQ Log Retrieved log file location override Leave blank to use the Communicator Ext one Browse Pini Nesesesesesesesesesesssesesess Ve nseeees Shark 200 Add Script Command Doc E167701 4 7 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application IMPORTANT You must download the same log configured for Energy or other commodity logging If you don t there won t be any energy data or other com modity data to import It is very important that you make sure to select the
91. gregate 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 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 d 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 and or Off Peak usage The Peak Demand rate you enter will be applied to peak demand in the selected rate periods when the bill is gener ated i e the Peak Demand usage is multiplied by the Peak Demand rate to get the Peak Demand charge C Electro Industries Gauge Tech Doc E167701 5 16 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e 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 kWh Reading This is the time 12 00 15kWh of the Util
92. he 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 The diagrams below and on the next pages show the differences between the Local and Network database server functionality Import Data From Meter Doesn t require setting up Any services or extra users V y To Ce Settings Editor Figure 1 1 Local Database Server C Electro Industries Gauge Tech Doc E167701 1 5 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application Import Data From Meter Reports PC Viewer Multiple PC s can access the Server Settings E Billing EXT Reports and Data Editor Reports PC Viewer l Figure 1 2 Network Database Server 6 Click Next You will see the screen shown below E Billing Ext 3 0 3 0 Setup Choose Components Choose which features of E Billing Ext 3 0 3 0 you want to install Check the components you want to install and unche
93. he number of pulses to the MMBTU usage value See the figure and example screen on the next page Electro Industries Gaugelech Doc F167701 5 9 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT 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 inplit Import Log Data Pulse Accumulator Y E Billing EXT MMBTU Application Commodity Pulse Values scaled from Condensate to MMBTU s 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 5 2 Scalar Example for Commodities Other Than Energy Edit Commodity Information Name MMBTU Scalar Custom Infinity Custom Scalar 0 0082345 ok Cance c Click OK to save your entries and close the screen click Cancel if you want to close the screen without saving your entries Electro Industries Gauge Tech Doc F167701 5 10 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e The other settings for rate structure
94. iewer Cc View By Date Time H E Show All Actions d Select Order Acknowledge Export Re Import Choose Actions All Errors to XML to Display o E a u Clear Clear Selected All Actions Actions e Refresh the action display by clicking the Refresh icon e 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 e 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 by selecting the two arrows icon Electro Industries Gaugelech Doc F 167701 9 2 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions e Select between Show All Actions and Select Unacknowledged Action Errors from the pull down menu e Clear all actions by clicking the red X You will see a Confirmation message win dow e 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 in 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 9 2 Best Practices When Configur
95. ilable months for the customer the months which contain usage data 3 Click the month s you want to create the usage report for Electro Industries Gaugefech Doc F167701 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 4 Click Options You will see the screen shown below Usage Report Options Output Options Output Path tro Industries E Billing Ext Reports Usage V Use default report name File Format PDF v Report Content Options Report Commodity kWh E Single Page Summary Overlay Interval Data Colorize TOU Z 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 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 e Report Commodity select the commodity you want to use from the pull down me
96. ing Log Files to I mport From NOTE The following guidelines are offered to help you configure the system to work best Other configurations will work e Configure the import location and import from the same computer this helps to prevent setting up a location that may be inaccessible from the computer doing the import The import location does not need to be the same computer that the data base server is running on e Use local files network shares and mapped drives can become inaccessible which can prevent the data from being imported It can also slow down the import as Shared files are slow to access It is just the connection between the configuration and the log data that should be local the data from the physical meter can be retrieved from another computer that maps to this one e Use globally accessible folders System locations such as Documents Users Appli cation Data or Temp are actually mapped to different locations for each user by the operating system This can lead to files disappearing if the current user changes If you do use these locations make sure they are the Public or All Users locations as these are shared between all users on the computer C Electro Industries Gauge Tech Doc E167701 9 3 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 3 Archive Database Clusters To ensure that your data is backed up
97. ion Edit Data Point 0000000020375 6 10 2013 5 45 PM Interval value decreasing but ni Timestamp Error Description 0000000020375 6 10 2013 5 45 PM _ Interval value decreasing but ni 6 10 2013 5 15 PM 8E 05 0000000020375 6 10 2013 6 00 PM Counter values decreasing for r 6 10 2013 5 30 PM 9E 05 0000000020375 6 24 2013 8 45 AM Interval values are missing in th 6 10 2013 5 45 PM 9E 05 Interval value de jing but no rollover detect 0000000020375 7 15 2013 8 30 AM Interval values are missing in th 6 10 2013 6 00 PM 9E 05 Error and Main_CPU 2 8 2013 9 28 AM Interval values are missing in th 6 10 2013 6 15 PM 8E 05 Intervals Main_CPU 2 21 2013 11 59 AM Interval values are missing in th around it 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 J m i Use to 1700ShameDr 6 10 2013 5 45 PM Interval value decreasing but ni New Value 0 Update Interpolate a dd ress 1700ShameDr 6 10 2013 5 45 PM Interval value decreasing but ni error Previous Clear Error Next 1700ShameDr 6 10 2013 6 00 PM Counter values decreasing for r 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 i E rror 1700ShameDr 7 15 2013 8 30 AM Interval values are missing in th det a i Is 1800ShamesDr 6 10 2013 5 45 PM Interval value decreasing but ni Sugg
98. itions 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 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 12 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 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc El167701 Vii 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
99. ity meter s Peak 12 15 17kWh Demand 12 30 16kWh 12 45 14kWh Location 2 has 3 meters The meters demand values are shown in the table below kWh Reading sss sssOou 0 sMs in this row together 12 15 4kWh 3kWh 1kWh adien 12 30 5kWh 1kWh 8kWh will have the fixed 12 45 15kWh 20kWh 9kWh rate 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 fixed charge rate since the Peak Demand at meter 1 Location 1 Is at 12 15 NOTE The Utility meter can be at any location C Electro Industries Gauge Tech Doc E167701 5 17 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings Fixed Charges Charge Type Coincidental Peak Demand Coincidental Peak Demand Name Coincidental Peak Demand Coincidental Peak Demand 0 00 Rate Coincidental Utility Meter es 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 enter a Name and Rate for the Coincidental Peak Demand and then choose the Utility meter from the pull down me
100. lds Default 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 Bill Report E Enable Enter the following Report select either Bill Report or Usage Report from the pull down menu Click Enable Enter a Subject for the email Enter the email text in the Body field Click OK NOTE What you enter here are the default settings for the email s Subject line and body text but you can change the subject line and or body text for a particular customer configuration see Section 5 3 The automatic Bill Report and Usage Report email feature lets you gener ate hundreds of automated bills or energy reports You can configure the system to send out bills to users automatically on a monthly basis Using this feature provides you with an automated accounting service and elim inates 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 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 5 5 5 Step 5 Configure the E Billing EXT Application Settings e Click Select to choose a company logo for the bill NOTE The image must b
101. ll month s worth of data a bill can be manually generated if there is at least two days worth of data To open the E Billing Dashboard Viewer software click E Billing EXT Viewer from the Start menu See the two examples shown below Microsoft Office Excel 2003 E Billing Ext E E Billing Ext Settings Editor Ps Adobe Photoshop CS5 64 Bit ge E Billing Et Viewer lt Uninstall E Billing Ext Settings Ed cond Communicator Ext Uninstall E Billing Ext Viewer E Billing Ext Settings Editor _ E Billing Ext Viewer Ps im NOTE You can also open the E Billing Dashboard Viewer from the E Billing Settings Editor just click the Dashboard Viewer icon in the Title bar E Billing Settings Editor File Configure Tools Help 5 4 ET Click this icon di to open the E Add Edit Edit Import Dashboard Billing Dash Customer Rates Provider AllLogs Viewer board Viewer 5 di 11567 E Locations E fa Mathers Building E Meters 0000010 Electro Industries Gaugefech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Step 7 Generate Bills You will see the E Billing Dashboard Viewer main screen shown below fF a6 E Billing Dashboard Viewer File Reports Tools Help P EBENE Generate View Bills Usage Dashboard Location Information All Bills Select a location from the left to begin Customers 11567 Locations Qs Mathers Buildi
102. ll of the meters in a building as well as any rate structures applied to usage for that building See the diagram below 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 5 1 Overview of Customer Locations Meters Rate Structures Electro Industries Gaugelech Doc F167701 5 2 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 5 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 E Billing Settings Editor main screen click the Configure Provider Information icon You will see the screen shown below Provider Configuration Provider Name BBH Holdings Provider Telephone 371 678 9090 Address 200 Middletown Road Altoona PA 16601 Payment Address BBH Holdings Remit Payment To PO Box 2546 Altoona PA 16601 Email Server Settings Email Report Settings Provider Logo 2 For the provider enter e Name e Telephone e Address e The address where payment should be sent e Email settings C Electro Industries Gauge Tech
103. ltiplier 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 CT Pl Ratios and system Hookup ee Prima PT Gencrenator Secaned ay See chem Wie Single Phase CI Denrminabw Secon aay yj CT Himei Peony Mice 1 Hirder 4 Meller 7 Meter 2 Meter 6 Mme 4 Meter 4 Meller 10 Meter 11 Mein 127 Halar 13 Meller 16 Meter 14 Heter 17 Meher 15 Meter 18 MP200 Metering System Device Profile this screen capture is from an MP200 S unit the single phase circuit configuration 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 Electro Industries Gauge lech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 2 Step 2 Set Up Communicator EXT Logging 5 Double click on the log you want to use You will see a screen that lets you select the values you want to log See the screens below and on the next few pages for the most commonly used Energy Energy in the Interval and other Commodity logging settings for the Nexus Shark and MP200 meters You can also refer to the table on page 2 11 NOTE For the MP200 metering system there is
104. ment 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 EIG 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 disassemble the SOFTWARE lil Transfers You may not distribute
105. move click No to keep the holiday Fixed Charges Click the Fixed Charges tab to configure single charges you want to be applied to the commodity when the bill is generated You will see the screen below Rate Structure Name Electricity Commodity kwh Number of Seasons Two Seasons z Weekdays Holidays Fixed Charges Rates Rate Times Rate Vis Seasons Rate Calendar gt ao Add Fixed Charge A Edit selected Fixed Charge City Tax Peak Demand Peak Demand 2 Remove selected Fixed ax Charge You can add a fixed charge edit an existing fixed charge or remove an existing fixed charge C Electro Industries Gauge Tech Doc E167701 5 14 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings a Click the Add Fixed Charge icon You will see the screen shown below Fixed Charges Charge Type i Fixed Charge Name Fixed Charge Rate Fixed Charges are a single monitary value which is applied to a whole bill regardless of the energy used This will typically be things like penalties taxes and credits b Select the Charge Type from the pull down menu You can select Fixed Peak Demand Flat Rate Tax or Coincidental Peak Demand e Fixed select this to add a single charge that is added to the bill when it is generated regardless of the usage amount
106. nd clicking Delete Make sure that you ve selected only the bills 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 Gaugefech Doc EF167701 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 8 Step 8 Usage Dashboard and Reports The E Billing EXT application gives you a usage dashboard and usage reports from the imported meter data Both the dashboard and the lets you perform detailed usage analysis and planning 8 1 Usage Dashboard One of the important features of the E Billing EXT application is the usage dash board It supports an Enterprise wide billing solution by allowing you to easily view Energy and other commodity usage data in a number of formats e View Usage by Day Week Month Year or a Customized Date Range Compare Usage Between Meters e View Costs e View Top Demand by Day Week Month Year or a Customized Date Range 1 To view the Energy Dashboard click on a Location from the E Billing Dashboard Viewer s main screen and then click the Usage Dashboard icon a6 E Billing Dashboard Viewer File Rep
107. ng a gh 12457 Locations Sy 14577 Locations m Sy 14678 Locations a gy 17850 Locations a amp 29087 Locations g amp 34567 Locations a amp 35678 Locations 7 1 1 Generate All Bills When you use this function the software scans for any bills that haven t been generated yet and generates them 1 From the E Billing 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 C Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 7 Step 7 Generate Bills 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 5 Building 6 5 1 2013 to 6 1 2013 ze 6 1 2013 to 7 1 2013 l _ Invalid records o 7 1 2013 to 6 1 2013 8 1 2013 to 9 1 2013 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
108. nges you make to it are not saved on the Database server 1 The list of all generated bills displays See the example screen below Bill Reports eo Save Bill View Bill Delete Bill Bill Period Reports Bill Type Generate Date 1234 2 E Building 4 1 8 1 2013 9 4 2013 11 1 2013 11 02 AM El 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 e 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 j Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Step 7 Generate Bills your computer A screen opens which lets you choose the location of the saved bill and give it a filename e 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 WARNI NG 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 a
109. ns 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 EIG 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 from EIG EIG gives no other express warranties guarantees or cond
110. nu f Click OK to save your settings and return to the Fixed Charges tab screen Your new charge is listed on the screen NOTES e 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 e 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 C Electro Industries Gauge Tech Doc E167701 5 18 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT 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 TOU 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 specific rates by Default On Peak Off Peak and Holiday rates If you have set up two seasons you can configure 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 1 Off Peak that rate is applied to all u
111. nu Usage reports are only generated for a single commodity at a time e Click Single Page Summary if you want to have the month week and day usages on the same page Doc E167701 8 8 g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports e If 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 e You can select to colorize either TOU or periods e 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 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 8 2 3 View Usage Reports When you generate a Usage report you have the option to view it right away Would you like to view the report now Click Yes to open the report See the sample reports beginning on page 8 11 C Electro Industries Gauge Tech Doc E167701 8 9 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 1 To view Usage reports at
112. orts Tools Help Generate View Bills Usage Dashboard All Bills Customers Bg 1234 E Locations B Building 4 fy Building 6 1 Bill Data Range Previous Month Views Usage Report Building 6 600 College Park Drive Altoona PA 16601 12 1 2013 Electricity 5 26 2013 9 28 2013 Bill 9 1 2013 j 9 1 2013 4 View Monthly Data Monthly Utility Bill Executive Summary Usage 4 Report Usage Dashboard lick this icon Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 8 Step 8 Usage Dashboard and Reports 2 The screen changes as shown below E eva 6 E Billing Dashboard Viewer gt 2 File Reports Tools Help el BIE Generate View Bills Location Info a All Bills Usage Dashboard Customers g amp 1234 amp Locations Building 4 fy Building 6 Click buttons O this Week Month Year lt lt foselect Custom date range for op Demand usage display Hide Meters Select Meter 1234 Building 6 1700ShameDr Compare To Not Set kWh 9 1 2013 Monthly kWh usage interval data for 1234 at Building 6 1700ShameDr September 2013 aus 1 O0ShameDr Prev AIV kh by interval Sep 2013 e The monthly usage is shown for the latest month s bill To see earlier months use the Prev button
113. 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 C Electro Industries Gauge Tech Doc EF167701 5 39 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 19 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 20 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 21 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 22 Select the rate structure you want from the pull down menu and click OK to close the screen NOTE You can also select Create New to add a new rate structure Follow the instructions for adding a rate str
114. 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 2 4 Average Hourly Usage GE Average Usage Min Usage Max Usage Average KWh hourly Usage 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 GE Average Usage Max Usage Average KWh weekday Usage sunday Monday Tuesday Wednesday Thursday Friday Saturday BBH Holdings 200 Middletown Road Altoona PA 16601 Page 13 of 14 Electro Industries Gaugetech Doc F167701 8 2 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Building 6 1700ShameDr 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 GE September 2013 EMM August 2013 1 kwh usage per Day 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 6 7 8 9
115. pared against Figure 1 5 Comparison to Last Month aligned by weekday GE September 2013 EJ August 2013 nyl ud 3 uns UON anl nyt ud JS uns UON anl nyt us 5 uns UON anl 800 700 600 500 400 300 kwh usage per Day 200 100 g Li 0 1 2 3 4 5 6 7 8 J 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Comparison to Last Year aligned by weekday GE September 2013 EJ September 2012 Cc o c as a I O E as 7 9 oo as WT D cio 7 9 E o 5 353 a E a 8 5 5 o a E a 8 5 5 a a E a B 5 5 Bob a E amp E a A 5 5 kwh usage per Day BBH Holdings 200 Middletown Road Altoona PA 16601 Page 9 of 14 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 8 17 8 Step 8 Usage Dashboard and Reports 8 18 Page 10 of 14 BERR Figure 2 1 22 Sun 22 Sun Doc E167701 15 Sun 15 Sun BBH Holdings 200 Middletown Road Altoona PA 16601 S lt Q 3 O 79 ko 6 o W g Ms a m g SS a F Yn mn x oc OW 7 co Rio S Mi wa z 5 E z cE CES E 222 5 n o on Mi S 5 T ee u Yc m eo sg te Bon EES SS Pa AAN S vo g c oo S H em N 0NA ODED 59 s 5 a 9 SOs bes eo ad Be a E mala oe a e s 5 8 8 8 g 8 5 e S S35 a D m N b 5
116. pboard 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 NOTE Export is also available from E Billing Settings Editor s Bill Data View 1 Use the options in the Output box to specify where to export the data C Electro Industries Gauge Tech Doc E167701 6 12 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing 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 select 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 2 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 3 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 e Tab should be selected if you plan to paste the data into a spreadsheet program e g the Microsoft Excel application e Space should be selec
117. r See the diagram below E Billing EXT Database Server Billing Data From Meters E Billing EXT Bill Settings Editor Import Billing Data from All Customers All Locations All Meters at Each Location or All Meters at a Location PC E Billing Dashboard Viewer View Imported Meter Data on Dashboard and Use to Generate Bills Usage Reports Trend Data Bills Usage Reports Trending Charts ija oa aay in bi hae POG heed eet Et he aai Figure 7 1 Bill Generation through the E Billing EXT Application IMPORTANT In Network mode bills and reports are automatically generated every twelve hours for any location for which there is a full months worth of data For Local Only mode you need to generate bills and reports manually You can also manually generate bills and reports for Network mode if you want j Electro Industries GaugeTech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 7 Step 7 Generate Bills 7 1 Generate Bills Manually Bills are generated manually from the E Billing Dashboard Viewer software 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 fu
118. r e Customer Name enter the customer s name this does not have to be unique e Address enter the customer s billing address e Telephone number C Electro Industries Gauge Tech Doc E167701 5 31 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings e Email Address e Report Email Settings after you click Apply you will be able to set up this field 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 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 shown on page 5 5 Use the screen to set up the email report settings for this customer 4 Click Add Location to This customer and continue to the next section 5 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
119. r Monitoring and Smart Grid Solutions Ei Electro Industries Gauge Tech Doc E167701 8 3 8 Step 8 Usage Dashboard and Reports To remove the second meter s data from the display click in the box again and click Clear in the meter selection window 5 To see usage cost data click the Usage Cost icon The example below shows usage cost for the two meters per week The display default s to the first week of the cur rent month use the Prev Next buttons to navigate to other weeks usage cost data r a6 E Billing Dashboard Viewer File Reports Tools Help Generate View Bills Location Info All Bills Customers cP 1234 amp Locations B Building 4 fy Building 6 Day Week Month Year Custom Usage Top Demand Cost Hide Meters Select Meter 1234 Building 6 1700ShameDr Compare To 1234 Building 4 kWh 9 1 2013 1800ShamesDr kWh 9 1 2013 Comparison of weekly kWh cost data for 1234 9 1 2013 Building 6 1700ShameDr compared to Building 4 1800ShamesDr GM 1700ShameDr GE 1800ShamesDr y Break Out nn oS b o ao Kh cost per day 6 To see top demand usage click the Top Demand icon The example below shows top demand for the two meters per day The display defaults to the first day of the month use the Prev Next buttons to navigate to other days data 7 The buttons on the left side of th
120. rate All Bills for All Customers Generate All Bills for Customer Generate Usage Reports 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 Section 7 1 1 steps 4 and 5 NOTE The Generate All Bills for All Customers option is the same as the Generate All Bills option explained in Section 7 1 1 The Leader In Power Monitoring and Smart Grid Solutions Cj Electro Industries GaugeTech Doc E167701 7 Step 7 Generate Bills 7 2 Individual Bills Bills can be generated individually for a specific location and bill period 1 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
121. rgy Commodities NOTE Most commodities are measured in this fashion A pulse output is the industry Standard method of measuring usage on any parameter whether electric gas con densate or anything else EIG meters natively measure electricity but also have the capability to report on g Electro Industries GaugeTech i The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 2 8 2 Step 2 Set Up Communicator EXT Logging usage from other commodities by using the pulse generated by these other types of meters For the Nexus meters we recommend the settings shown in the screen below for logging commodities other than Energy Select from pull down menus See a Group ub Group Stored in log as Scaled Primary Selectable temis Selected Item s Internal Input 1 Internal Input 2 Select the Input that is recording the Internal Input 3 f Internal Input 4 commodity s pulse meter and click Add Internal Input 5 Internal Input 6 Internal Input Internal Input 6 Aggregator 1 Aggregator 2 Aggregator 3 Aggregator 4 Total bytes used 8 Estimated Log Timespan 129 days 1hour 30min Osec Bytes remaining 246 Total Records 124518 NOTE With Nexus meters each meter can count up to 8 different pulses at differ ing speeds Each of these inputs can be mapped to a different commodity The Shark 200 meter can perform a similar function it has 4 inputs maximum per
122. ricity Charges Total Due 3 650 14 3 050 14 BEH Holdings 200 Middletown Road Altoona PA 16601 571 678 9090 1234 College Park Apartments 200 College Park Drive Altoona PA 16601 Total Charges Customer 1334 Statement Date 11 1 3013 Bill Period 8 1 2013 9 1 2013 3 650 14 Location Building 4 Provider Information Customer Information Location Electricity Charges kWh Meter Usage Hoi EE 203 dan Feb hiar Apr May Jun Jul Aug Sep Of Hoy Des Usage Chart Meter 1800 ShamesDr Total PREV PRES Usage 32463 45002 16539 Rate Structure holiday Peak Demand Season One OF Peak Season One Cu Peak Season Two OH Peak Season Two On Peak City Tax 0 02 Total Electricity Charge Total Due 3 650 14 Holiday Peak Demand Off Peak On Peak Tax Fixed charge Total 3 650 14 If this bill was generated from Interval Energy data there will be no PREV ious or PRES ent usage values Electro Industries Gaugefech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 7 Step 7 Generate Bills 7 3 View Bills You can view generated bills either by clicking the View Bills icon in the E Billing Dash board Viewer s main screen or by clicking Reports gt View Bills from the screen s Title bar NOTE The viewed bill is just a temporary file that has been downloaded from the E Billing EXT Database server where the bills are stored Any cha
123. rieve the Logs From the Meter with Script amp Scheduler i Application at 8 am and 8 pm Daily Stored Log mpor n og p a E Billing EXT with Automatic Import at Midnight daily Figure 4 2 Timing of Log Downloads and Data Import Example C Electro Industries Gauge Tech Doc E167701 4 2 The Leader In Power Monitoring and Smart Grid Solutions 4 Step 4 Set Up Automatic Log Downloads with the Script amp Scheduler Application 4 1 Setting Up the Log Download Scripts Follow these instructions to set up automatic log downloads with the Script amp Scheduler application 1 Click Start gt All Programs gt Electro Industries gt Script amp Scheduler to start the application You will see the screen shown below r x p E Scheduler stopped Run Sto Active scripts Schedule Script Name Next Run Time Last Run Time Current status 6 30 2012 5 48 04 PM Scheduler is running 6 30 2012 5 48 30 PM Scheduler stopped SCRIPT SCHEDULER STATUS Add Script Reset Alarm Options Delete Script Clear status Exit If the application is running the box at the top has a red light blinking in it and the message Scheduler is running appears under the box click Run Stop The appli cation will stop the box will be empty and Scheduler stopped will appear under the box 2 Click Scripts You will see the screen shown below Create New Open Delete Script Up to 300 script Current Scripts 5001
124. rnal databases such as an HMI EXT application database 16 Select the commodity from the pull down menu Once the data has been imported it will be tracked by the commodity e You can select only one channel per commodity per meter e g Total Watt hours for kWh e A meter can have multiple commodities See the diagram below Tracking Energy Usage through J Voltage and Current Inputs Pulse Input 1 Gas Usage Figure 5 3 Example of Meter Measuring Multiple Commodities Pulse Input 2 Condensate 17 Auto adjust Rollover is the default selection on the screen The unscaled rollover field will display the settings from the Communicator EXT 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 18 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 ata 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 things like hallway and
125. rs WAR hours VWid Hours Watt hours 4 Recenved Watt hours B Recenved Wratt hours C Recered Wiatt hours 4 Delivered Wiatt hours B Delivered Watt hours C Delivered AR hours A AA hours B AA hours C MAR hours A AN he 0 Time Available Selected lternfs Energy ITI Watt hours received Log Record Total byt 213 days 5 hours 30 minutes Bytes remaining Save Profile Load Protile eS SS Se SO Electro Industries Gauge lech The Leader In Power Monitoring and Smart Grid Solutions Doc E167701 2 Step 2 Set Up Communicator EXT Logging The MP200 metering system s historical logs 2 MP200 Y and 3 MP200 S are pre configured to log Energy in the Interval The only thing you can select for them is the logging interval which should be set at 15 minutes 5 MP200 Main CPU Serial Number 0116557025 V Switch 3 i File Tools View Help E General Settings CT PT Ratios and System Hookup Historical Log Profile 3 Speen Energy in the interval and Input Accumulators System Settings Communications g Energy Settings amp Alarm Settings i a Trending Profiles Logged Data Item s Th e log g In g i Historical Log Profile 1 Interval Energy Watt hours Received Meter f i el d s are p re j Historical Log Profile 3 i i Historical Log Sectors CO nfi g u red an d Interval Energy Watt hours Received Meter2 can t be Interval Energy Watt hours Received Meter2 amp
126. ry 1st 1st of January 1 1 2013 Easter Easter 3 31 2013 Memorial Day Last Monday of May 5 27 2013 H Edit selected Holiday July 4th 4th of July 7 4 2013 Labor Day First Monday of September 9 2 2013 pa eae selected Veterans Day 11th of November 11 11 2013 Thanksgiving Fourth Thursday of November 11 28 2013 12 25 2013 Christmas 25th of December 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 the Holiday rate Electro Industries Gaugetech Doc F167701 5 12 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings a Click the Add New Holiday icon to open the screen shown below Holiday Name Every O Nearest Monday C Nearest Weekday The First sunday of January Specific Day Thursday October 03 2013 Special Days Fader b Enter a name for the holiday c You have these options for setting up the holiday e 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
127. s Editor Main screen click Tools gt Edit Data Errors You will see the screen shown below i Scan and Edit Data Errors Search Filter Timestamp Error Description m Select the cus tomer location Customer Id Any Location Id Any meter channel Meter Id Any you want to see Channel Any errors for ey W P r Filter Scan 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 Gaugetech Doc F167701 6 14 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 3 Click Scan to cause the software to begin looking for 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 P Scan and Edit Data Errors X Timestamp Error Descript
128. s When Configuring Log Files to Import from 9 3 Archive Database Clusters 9 4 Restore Database Clusters 9 5 Additional Database Options 9 6 Clear Meter Data 9 7 Option Screens 9 6 1 Path Setting 9 7 2 Configuration Setting 9 7 3 UI User Interface Setting 9 8 Performing Tasks Using Command Line 9 8 1 Import Data Using Command Line 9 8 2 Generate All Bills Using Command Line Glossary Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 9 1 9 3 9 4 9 6 9 9 9 11 9 12 9 13 9 14 9 15 9 15 9 15 GL 1 Table of Contents TOC 3 Table of Contents This page intentionally left blank 5 Electro Industries GaugeTech Doc F167701 TOC 4 i The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 Step 1 Install the E Billing EXT Application 1 1 Overview The E Billing EXT application is a fully customizable software application that lets you create and view an Energy Dashboard analyze costs and automatically generate detailed Energy usage reports and usage bills using 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 information on these applications The E Billing EXT application was created for use with Elec tro Industries
129. sage that occurs during Off Peak times during the period designated as Season 1 You will see the screen shown below Rate Structure Name Electricity Commodity kWh Number of Seasons Two Seasons v Weekdays Holidays Fixed Charges Rates Rate Times l Rate Vis Seasons Rate Calendar Charge per unit e Add Rate Holiday 0 2 Off Peak Season One 0 21 On Peak Season One 0 23 ge Edit selected Rate Off Peak Season Two 0 22 Remove selected Rate On Peak Season Two C Electro Industries Gauge Tech Doc E167701 5 19 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings a If you want to use more rates than Off Peak and On Peak click the Add Rate icon You will see the screen shown below Edit Rate Name Surcharge Season Charge per Unit 0 03 b Enter a name for the rate select 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 e 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
130. sks and provides a user friendly interface to configure settings e Advanced provides access to all options and should only be chosen for advanced users Electro Industries Gaugelech Doc F167701 9 13 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions 9 7 3 Ul User Interface Setting Except for one setting the E Billing Dashboard Viewer and E Billing Settings Editor Option screens have the same UI settings 1 Click the UI tab You will see the screen shown below r Options ee k paa Paths Configuration Ul Enables Warn on software close Warn on startup if the root path iv 7 Show debug window 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 checkbox to show the debug trace window while the software is running 3 Click OK to close the screen and apply your settings Doc E167701 9 14 g Electro In
131. t 11 1 2013 12 15 PM 1234 at Building Software E Billing EXT demo_logs E Report Error 11 1 2013 12 15 PM Report 11 1 2013 5 20 PM 1234 Source File C Users ndeibleriDesktop Framemaker Sottw Report 11 1 2013 5 21 PM 1234 Report 11 1 2013 6 13 PM 1234 Meter ID 1800ShamDr Action Import 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 e If you right click on an action you can select to e Repeat the action e g re import data if the action is Importing C Electro Industries Gauge Tech Doc E167701 9 1 The Leader In Power Monitoring and Smart Grid Solutions 9 Additional Features and Advanced Fucntions e Acknowledge All Errors they won t show in red anymore e Delete Selected Actions remove the action from the action log e Hide Details Show Details this option toggles between hiding or display ing the detailed information on the right side of the screen e f you right click on an Error you have an additional option e 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 Action Log V
132. t Dashboard Customer Rates Provider AllLogs Viewer Customers B Fs 1234 Locations amp Js Building 4 Meters 1800Dr Qs Building 6 Meter Information 1800Dr Edit Imported Data 0123995130 Shark 200 Meter Specifics Remove Meter amp Meters 1700ShDr Channel W hours Received e Edit Meter E Import logs now 2 From the Title bar click Tools gt 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 Click OK to close the message window Electro Industries Gauge Tech The Leader In Power Monitoring and Smart Grid Solutions right Type in DELETE to confirm the deletion of all the log data for 1272poller Doc E167701 9 Additional Features and Advanced Fucntions 9 7 Option Screens Both the E Billing Settings Editor and E Billing Dashboard Viewer have an Options screen You access this screen by clicking Tools gt Options from the main screen s Title bar The screen has three tabs for settings Paths Configuration and UI The settings are the same on both screens except for the Paths settings See the screens below Paths Configuration Ul Paths Configuration Ul j Default Bill Definitio C
133. te 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 previously generated bills will not e 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 the 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 a Configure Rate Structures Rate Structures Q Add new Rate Structure C Electro Industries Gauge Tech Doc E167701 5 29 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT 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 5 8 0 dity List a Commodity List gp ae ae Commodi 4 e Add new Commodity kGallon kWh Negative electricity Edit selected Commodity gt R
134. ted 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 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 4 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 C Electro Industries Gauge Tech Doc E167701 6 13 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data 5 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 6 1 7 Correct Data Errors Following is the recommended procedure for correcting data errors for example zero values due to problems in communication 1 From the E Billing Setting
135. ter only you can log Energy but not pulse accumulations as it does not have Digital Inputs The instructions for this step are in Chapter 2 Step 3 Using the Communicator EXT application run initial log downloads for your meters This step is necessary to get the basic log data from the Communicator EXT application into the E Billing EXT Database server The instructions for this step are in Chapter 3 Step 4 Set up the Script amp Scheduler application to retrieve the meter logs on a regular basis e g every 12 hours and convert them into the log database files that the E Billing EXT application needs for generating your customer bills The instruc tions for this step are in Chapter 4 Step 5 Configure the E Billing EXT application settings provider customer cus tomer locations rate structures meters at location The instructions for this step are in Chapter 5 Step 6 Data importing from the log database files to the E Billing EXT Database server If you are using the Network server setup data importing is automatic If you are running the Local Only setup you can set up automatic importing of data through Windows Task Scheduler The instructions for this step are in Chapter 6 along with instructions for viewing and correcting data errors The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 1 11 1 Step 1 Install the Applic
136. termine the charge for the amount of usage the customer has for the billing period e g total kWh 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 k 1000 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 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 E Billing EXT application 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 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 5 8 5 Step 5 Configure the E Billing EXT Application Settings 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 t
137. th 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 The Leader In Power Monitoring and Smart Grid Solutions Cj Electro Industries GaugeTech Doc E167701 5 TRANSFER RESTRICTIONS In no event may you transfer assign rent lease sell or otherwise dispose of the SOFTWARE the License Key or the written materials ona 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 POLICY 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 license You hold Updated versions of the SOFTWARE will be subject to
138. 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 1 4 Average Hourly Usage Min Usage GE Average Usage Max Usage ad ee ee eee baea ee ee Se eee 59 000 9 1 1 2013 2 00 00 PM Average KWh hourly Usage 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 GE Average Usage Max Usage Min Usage q b ae ee a AE RAA aa AT TTM ax 59 000 971172013 2 00 00 PM Average KWh weekday Usage i J 1 i j 4 1 i 4 1 sunday Monday Tuesday Wednesday Thursday Friday Saturday BBH Holdings 200 Middletown Road Altoona PA 16601 Page 8 of 14 C Electro Industries Gauge Tech Doc E167701 8 16 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports College Park Apartments September 2013 Usage Summary Report Building 4 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 com
139. the power or other commodity 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 Each location can have one meter or multiple meters attached to it If there is more than one meter the software will aggregate the usage of those meters to generate a total billing amount peak demand and usage report Electro Industries Gaugelech Doc F167701 5 32 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 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 Edit Location Information Location Name Building 500 Bill Period 1st of the month Location Address 500 College Park Drive Altoona PA 16601 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 You will see the screen shown below Select the bill period 4 From the pull down menu select the day of the month you want 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 The Leader In
140. 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 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 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 5 4 29 5 Step 5 Configure the E Billing EXT Application Settings 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 You will see the screen shown below NOTE You will only see the Seasons tab if you selected more than one season Rate Structure Name Commodity X Number of Seasons Four Seasons X Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Season Names Season Transition Dates Season One Season One March 21 B Season Two Season Two June 21 Bv Season Three Season Three September 21 Gr Season Four Season Four Decembeg 21 vr Enter Name Select End for the Date for
141. tion is the download engine for collecting data from a meter The Script amp Scheduler application is the mecha nism used by the Communicator EXT application to automatically collect data from every meter within the system The Script amp Scheduler application serves as a stand alone module for the Communicator EXT software package It is automated data retrieving and processing software You will use the Script amp Scheduler application to automatically download the billing log data which you set up through the Communicator EXT software You do this by setting up the Script amp Scheduler application to download the logs containing the billing data from your billing meters at programmed intervals After the log data is downloaded the Log Converter application changes the data into the correct format for the log database this happens automatically within the software NOTE You should set up the Script amp Scheduler application to download the logs more often than you will be importing them into the E Billing EXT application The reason for this is that downloading logs from many meters can take a long time and you need to download all of the relevant data before you import the data and gener ate bills from it For example if you are importing meter data once a day we recom mend you schedule the log downloads twice a day every 12 hours Internal Logged Data in Meter Ret
142. tions E a 17850 Locations a 29087 Locations Follow these basic steps to set up the 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 pay ment 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 C Electro Industries Gauge Tech Doc E167701 5 1 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 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 customer 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 For example if your customer owns three apartment buildings you would set up each building as a location and enter a
143. to commodities This includes Energy e g Total Watt hours and pulse accumulations e g a Digital Input channel 12 If you are using a Communicator EXT 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 Meter settings tor 90000014 Imported NOTE The Import Settings function will only fill in information that has not already been entered For example if you have already filled in the Meter Name it will leave that as is If you want to get the information from the database but have already entered values clear those entries before clicking the Import Settings from Meter Log File icon TIP EIG highly recommends importing all the meter configuration data This automated tool makes the meter configuration task much simpler The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc E167701 5 37 5 Step 5 Configure the E Billing EXT Application Settings 13 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 oo00000
144. to return to later months use the Next button e You can select Day Week Year or Custom to enter a custom date range by clicking the radio buttons to the right of the Top Demand icon These options let you view usage data for any period you would like the default selection is month Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 8 Step 8 Usage Dashboard and Reports 3 You can select another meter to compare usage click in the box next to Compare To You will see the entry fields shown below E Week Month Year manent pe 10 Mete kWh 9 1 2013 r 1234 Building 6 1700ShameDr Channel a Monthly kWh usage interval data for 1234 at Buil ms ems 7 0ShameLr 4 Select the meter channel and date from the pull down menus and click Apply The screen will redisplay showing both meters data a6 E Billing Dashboard Viewer File Reports Tools Help Generate View Bills Location Info All Bills Customers CPs 1234 amp Locations g Building 4 m Week Month Year Select Meter 1234 Building 6 1700ShameDr Compare To 1234 Building 4 kWh 9 1 2013 1800ShamesDr kWh 9 1 2013 Comparison of monthly kWh usage interval data for 1234 September 2013 Building 6 1700ShameDr compared to Building 4 1800ShamesDr aus 1700ShameDr m 1 900ShamesDr fe Building 6 kh by interval Sep 2013 The Leader In Powe
145. to the Database Server If you are running the E Billing EXT application on a PC that is not the database 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 E Billing EXT application s E Billing Bill Settings Editor the appli cation tries to connect to the database on the PC you are using If the database 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 Network 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 gt Connect to Database from the E Billing Settings Editor Title bar and continue with the instructions below Database Type PostGre Database Database Settings Data Source 127 0 0 1 Local Only Database Port 5432 V Default V Requires Login Username billing Password OK Cancel 1 Enter the information for the database server the settings above are examples only e Database Type EIG is only supporting a PostGre database for its database t
146. u want to archive click Continue if you do not want to archive click Exit The warning message goes away and you see the fields shown below co a Database Maintainance Archive Databases Restore Databases Clear Databases Server Status This archives the entire database cluster so you can later restore it if a problem occurs Select the location to archive to and click Begin Archive Location Browse v Archive to single file Begin Archiving 3 Click the Browse button to choose the location you want to save the archive to 4 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 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 5 Click the Begin Archive button You will Archive Databases see the message window shown on the This may take a long time for large databases Please be patient and do ri g ht C i ck O K to CO nti nue not modify anything while the archiver is running 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 C Electro Industries Gauge Tech Doc E
147. ucture in Section 5 2 5 4 1 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 The Leader In Power Monitoring and Smart Grid Solutions C Electro Industries Gauge Tech Doc EF167701 5 40 5 Step 5 Configure the E Billing EXT Application Settings Location Meter 1 Meter 2 E Billing EXT Application Imports data from meters Generates Bill for Location 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 5 4 Totalizing Meters Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 5 4 2 Importing External Data If you are setting up the E Billing EXT application for use with external data as opposed to the Communicator EXT application log data such as an HMI EXT application database file there are some unique considerations Below is an example of an HMI EX
148. ure 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 hd Weekdays Holidays Fixed Charges Rates Rate Times Seasons Rate Calendar Day Type Sunday D Weekday Weekend Monday Weekday D Weekend Tuesday Weekday D Weekend Wednesday Weekday Weekend Thursday Weekday D Weekend Friday Weekday Weekend Saturday D Weekday Weekend Store Exit C Electro Industries Gauge Tech Doc E167701 5 7 The Leader In Power Monitoring and Smart Grid Solutions 5 Step 5 Configure the E Billing EXT Application Settings 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 e 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 de
149. wer but you can only modify the values using the screen from the E Billing Settings Editor To view this screen from E Bill ing 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 buttons to scroll the data eThe preferred method for correcting data errors is described in Section 6 1 7 C Electro Industries Gauge Tech Doc E167701 6 11 The Leader In Power Monitoring and Smart Grid Solutions 6 Step 6 Importing Data eThe buttons on the top of the screen and their functions 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 6 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 B lele le 6 1 6 Export Meter Data You can export all of the data by clicking the Export Data icon on the toolbar You will see the screen shown below Data Export Options Fomat Include Column Headers E Include Biling Event Information File Options Filename This screen lets you export the data to either the cli
150. will be used and disclosed by EIG solely for purposes of such inspection and audit and for enforcement of EIG 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 15 CONSTRUCTION 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 Industries GaugeTech EIG C Electro Industries Gauge Tech Doc F167701 viii i 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 ji License Agreement for the E Billing EXTTM Software Application ii 1 Step 1 Install the E Billing EXT Application 1 1 1 1 Overview 1 1 1 2 Install the E Billing EXT Application 1 3 1 2 1 Installation Procedure 1 2 1 3 Connect to the Database Server 1 9 1 3 1 Specify the Database Server 1 9 1 4 Enter a Software License Key 1 10 1 5 Steps for Using the E Billing EXT Application 1 11 2 Step 2 Set Up Communicator EXT Logging 2 1 3 Step 3 Initial Download
151. 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 INSTALLATION 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 DOCUMENTATION AND MATERIALS YOU MAY BE LIABLE TO EIG FOR DAMAGES AND YOU MAY BE SUB JECT TO CRIMINAL 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 EIG 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 Cj Electro Industries Gauge Tech Doc E167701 The Leader In Power Monitoring and Smart Grid Solutions license limitations restrictions and other terms in this Agree
152. 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 C Electro Industries Gauge Tech Doc El167701 1 10 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application 1 5 Steps for Using the E Billing EXT Application As mentioned at the beginning of this chapter the E Billing EXT application gener ates bills using either Communicator EXT log databases or the polling engine of the HMI EXT application Because the HMI EXT application is specifically configured for each customer site data setup for the E Billing 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 log ging and to use the E Billing EXT application to generate usage reports and bills Step 2 Using the Communicator EXT application configure your meter s to log the values you want to use for Energy and other commodity logging These values can be any Energy value e g Watt hours Received or pulse accumulator e g a Digital Input for the Shark 200S me
153. ype 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 C Electro Industries Gauge Tech Doc El167701 1 9 The Leader In Power Monitoring and Smart Grid Solutions 1 Step 1 Install the Application e Port the port to connect to the server on By default the port is 5432 which dis plays when you click the Default checkbox e 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 E Billing EXT application you need to enter the software 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 E Billing Settings Editor click Help gt Upgrade User License You will see the screen shown below i e License Info Ste Current License i User billing Unique ID Expiration Date 2013 12 01 Permissions bill_settings config permission view setting view bill settings config license_unlimited normal license sales_demo license normal Upgrade License Enter license key here and click Upgrade License Key 2 Contact EIG s inside sales staff at sales electroind com In the email give

E-Billing EXT Application User Manual V.1.02

Contents

Download Pdf Manuals

Related Search

Related Contents