Export Energy-Data to Spread-Sheet Program

The data collected by eGauge can be exported to a spread-sheet program such as Excel, OpenOffice Calc, or Gnumeric by clicking on the "->CSV" button in the top-left corner of the graph displayed on the eGauge home page. Clicking on this button opens a dialog which allows you to select the type of data to export, the time-range for which data should be exported, and the resolution of the data. Specifically, the following fields can be set in the dialog:
Export Type:

Whether to export average power used/produced during consecutive time intervals or whether to export absolute meter readings. Average power is reported in units of kilo-Watts (kW), energy meter readings are reported in units of kilo-Watt-hours (kWh).

From:

The starting date and time of the period that should be exported.

To:

The ending date and time of the period that should be exported.

Interval:

The time-interval between data points. A value of "1 day" requests that one data point is exported per day. A value of "1 hour" requests that one data point is exported per hour, and so on.

By default, the data currently being displayed in the main graph will be exported with a resolution of one data-point per day.

Graphing the Exported Data

If you wish to graph the exported data, you'll notice that the data is sorted in reverse chronological order (youngest data-point is first, oldest is last). To graph the data, you will usually want to reverse this order, so that in the graph, time progresses from left to right. To achieve this, selected all the data, then use your spreadsheet's "Sort" function to re-sort the data in increasing order of the first column (Date & Time).

Settings

General Settings

Date & time when recording started:

This option specifies the date and the time at which eGauge is considered to have started recording data. Any data recorded prior to this point in time will be ignored. Changing this value doesn't actually delete any data, so this point can be freely moved forward or backward, without fear of losing data. As a special case, this option can be set to the value "now" (without double-quotes) to establish the current date and time as the starting point. This is particularly useful after installing (or moving) eGauge since the data recorded prior to installation most likely is irrelevant and should be ignored.

Geographic location:

This option specifies the geographic location at which eGauge is installed. For privacy-reasons, the coordinates are usually offset a bit so that they do not identify the exact site at which the device is installed.

For the latitude, positive values are nothern and negative values are southern latitudes. For longitude, positive values are eastern and negative values are western longitudes.

Clicking on the "map" link opens a new window that displays the currently entered location on a map.

Clicking on the "address lookup" link opens a new window to Maporama, which provides a convenient way to lookup the geographic location of an address.

Min. interval for public usage data:

This option can be used to limit public availability of the electric usage (consumption) data. Normally, this data is available at 1-minute resolution. When setting this option to any value other than "No restriction", usage data will be limited to the selected resolution. For example, with a setting of "1 hour", resolution is restricted to 1 hour. That is, all usage data will be available as 1-hour averages only, thus enhancing privacy.

Full-resolution data is always available to local users and authorized users.

The recommended setting for this option is "No Restriction". However, privacy- or security-concerns may warrant setting this option to another value.

Proxy-server hostname:

This option specifies the hostname (or IP address) of the machine that is running the proxy-server. The proxy-server makes it possible to access eGauge at URL

http://name.
Mapping formulas:

These options specify how the individual measured power/energy-values get mapped to total usage and generation (production) figures. The most common configuration, where CTs are used to measure power coming in from the grid (utility) and from a solar inverter would be described with the following two formulas:

	use = "Grid" + MAX ("Solar", 0)
	gen = "Solar"
      
The first line says that total usage is the sum of the power measured coming from the Grid and the power coming from the Solar inverter, if it is positive (if the solar system isn't producing any power, it's consumption is already measured as part of the Grid power). Similarly, the second line says that the generated power is simply the power coming from the Solar inverter (note this figure may be negative if the inverter uses power, e.g., when the sun doesn't shine).

In general, a formula consists of a sequence of terms, each of which may be added to or subtracted from the total figure. In addition, there are MIN and MAX operators, which allow taking the maximum or minimum, respectively, of a source (such as "Grid" or "Solar") and a constant value.

Channel scales:
These options specify the scaling factor for the various data-acquisition channels. Do not change these unless you absolutely know what you're doing. Entering incorrect values here may render the device unusable.

Network Settings

Hostname:

This option specifies the hostname of the eGauge.

Caution: The server at http:/// authenticates this name. Thus, if you change this name without notifying the operators at http:/// you will lose connectivity to http:/// and a service call may be required to restore connectivity.

Automatically obtain address with DHCP:

This option controls whether the device uses manual settings for the network configuration or whether the settings are automatically obtained via the DHCP protocol. When this option is selected, the remaining network settings are grayed out, since their values will be obtained automatically.

IP address:

This option defines the static IP address used by the device (e.g., 192.168.1.77).

Netmask:

This options defines the IP network mask used by the device (e.g., 255.255.255.0).

Network:

This option defines the IP network number used by the device (e.g., 192.168.1.0).

Broadcast address:

This option defines the IP broadcast address used by the device (e.g., 192.168.1.255).

Gateway address:

This option defines the IP address of the gateway used by the device (e.g., 192.168.1.1).

Name server 1-4:

These options define the IP addresses of up to four DNS servers. These servers are used by the device to resolve domain-names, such as "pool.ntp.org".

HomePlug

eGauge communicates with your computer/LAN using the existing powerlines in your home or business (i.e., the wires that provide 120V power to the outlets). The technology eGauge uses for this purpose is called HomePlug. For technical reasons, the reach of the HomePlug signal is usually constrained to a single building. More specifically, any power transformer will stop the HomePlug signal. For this reason, most home- or business-owners do not have to worry about the HomePlug signal being detectable by their neighbors, so there is little risk of a third party intercepting the communication. Furthermore, due to the nature of how HomePlug works, even if the HomePlug signal were detectable, it would be virtually impossible for a third-party device to intercept the point-to-point traffic between two other devices. The net result of this is that for most owners of HomePlug devices, privacy of communication is assured without any further steps.

Having said that, for extra security and when using HomePlug devices in an apartment or condo, where multiple residences may be powered by a single transformer, it is possible to increase security by establishing a secret password which is used to encrypt all HomePlug traffic. By default, HomePlug devices are configured to encrypt communication using the default password "HomePlug". The HomePlug settings screen on eGauge can be used to change the default password to a secret password. When changing the password, it is important to change it on all your HomePlug devices at the same time. For this reason, the HomePlug settings screen lists all the HomePlug devices eGauge has detected. For each device, the MAC Address and current communication speed are shown. If available, the name of the vendor of the device is also displayed. To change the encryption password, write down the MAC address and Device-ID of each HomePlug device you need to change (except for eGauge itself). This information can be found on the device label (see below). Note that you may need to unplug the device to be able to see the label. Once you collected this information, go to the HomePlug settings screen and enter it in the table. Specifically, for each device, find the table row matching the device's MAC address and then enter the Device-ID in the corresponding column. Once this information is entered, type the desired password in the text entry box labeled "New encryption password", then click on "Set Password". eGauge then establishes the new encryption password on the selected devices as well as itself. If an error occurs (e.g., due to an incorrectly entered Device-ID), eGauge restores the original password and displays an error message.

HomePlug Recovery

If disaster strikes and for some reason the HomePlug encryption password does not properly get established on all devices, you will lose communication with eGauge. This can be fixed by installing a HomePlug configuration utility on your computer. This utility can be downloaded for free from ActionTec's web-site:

ActionTec Configuration Utility
This utility works on Windows computers only. For a corresponding Linux utility, please contact eGauge support at at support@egauge.net.

Once the HomePlug configuration utility is installed on your computer, you will be able to configure the encryption password of each of your HomePlug devices, including eGauge. However, in this case, you will need the Device-ID of the eGauge device. This can be found on the label on the bottom of the enclosure. Since the eGauge device is often difficult to access, you can also request the Device-ID from eGauge support at support@egauge.net. The device name (e.g., "eGauge125") and information authenticating you as the owner of the device will be needed before the Device-ID can be sent to you.

Device-ID:

The Device-ID is a 19 character long password that is unique to each HomePlug device. It has the form:

	XXXX-XXXX-XXXX-XXXX
      
where each "X" is either an uppercase-letter or a number. The Device-ID can be found on the label of each HomePlug device. Different vendors use various names for the Device-ID: Netgear calls it "PWD", IOGear calls it "DEK", eGauge and ActionTec call it "Device ID" or "DEK". Note that for most HomePlug adapters, you will need to unplug the device before you can see the label with this information. A typical label for the Actiontec HomePlug adapter is shown below:

BACnet

Enable BACnet support:

Check this box to enable BACnet support. Unless you know what BACnet is, it is best to leave this box checked off.

Protocol to use for BACnet datalink:

eGauge supports BACnet communication via raw Ethernet packets or through BACnet/IP (BIP), which encapsulates BACnet data inside UDP/IP packets. Use this selection box to choose between Ethernet and BIP, whichever is appropriate for your BACnet environment. Note: BACnet defines other types of datalinks, such as ARCNET, MS/TP over RS-485, Point-To-Point over RS-232, and LonTalk, but the eGauge hardware does not support those directly.

BACnet device id unique to this device:

Each BACnet-capable device needs to have a unique device instance number, which can be any number between 0 and 4,194,303. Enter the desired number for this eGauge.

Password

Note: Unless "Allow Remote Administration" is checked, it is not possible to change the password (or any other settings) unless you're connected to eGauge directly from your LAN (not through the Internet). The easiest way to ensure this is to click on the LAN Access link here or on the top right of any of the device's web-pages.

Old Password:

For security reasons, you need to first enter the existing password before being allowed to establish a new eGauge password. The factory-default for this password is "default" (without quotes).

New Password:

Enter the new password here. Only letters and digits are allowed in the password string. The password should be at least six characters long and a word that is hard to guess, but easy to remember.

Confirm Password:

Reenter the new password here for confirmation.

Allow Remote Administration:

Check this box if you want to be able to change settings from the Internet. By default, settings can be changed only when connecting from a computer that is on the same network as the eGauge. Please establish a strong password before enabling remote administration.

Reestablish Default Passsword:

Click on this button to reset the "owner" password to its default. For safety-reasons, this will also clear the "Allow Remote Administration" checkbox.

Even after all this time, the Sun never says to the Earth "you owe me" --- Hafiz, Persian Poet of the 1300s