HAB Access

Today we updated ourselves on the following information. Access 95 and 97 are supported. HABAccess can write to databases of either format and will create databases that can be opened by either version. (HC83). It is native 32 bit Windows application (HC43) because HABDDE is now a native 32 bit Windows application. As a result of porting to 32 bit, the limitation of 64K of data for each DDE link has been eliminated. (HC43)

If connection to the first host fails, HABDDE attempts to connect to the second host before delaying. (HC82)
HABDDE provides a method for an application to query for the name of the connected host. Specifying a DDE link with a topic of “HABDDE” and an item of “HOST” returns the name of the connected host, or a null string if not connected. (HC140)

Two nodes or addresses can be specified for each host to support dual-redundant TCP/IP networks. The potential drawback is that if the link to the Sampler is not established, no data is written to Access. In the previous version, rows were inserted indicating that no data was available Items linked to multiple records can be hot-linked. (HC41). HABAccess options are saved between executions of HABAccess. (HC35) HABAccess can optionally update rows in an Access table instead of inserting new rows each sample. The update feature requires identifying which items are the key for the table by setting the key column attribute when creating or editing items (HC16).

The alias database is no longer specified via an ODBC data source definition. The location and name of the alias database can be specified via the HABAccess menu under Options. Changing the alias database location also changes the location that HABDDE uses. HABAccess now connects directly to the Sampler to retrieve HABITAT data rather than using HABDDE. The host configuration information can be changed via either HABAccess or HABDDE.

This provides better accuracy and reliability than the previous version and allows the start time to control exactly when the sample is performed. For example, if a sample rate of 1 hour is specified with no start time, the sample will be performed at the top of the hour based on the EMS time. If a start time of “01-JAN-1979 00:10:00” is specified, then the sampling will be performed at exactly ten minutes past the hour each hour.

When HABAccess periodically records data, the time that the data is sampled is now determined by the Sampler based on the clock on the EMS system. The sample periods 24 hours are supported (HC96).

Add Your Remarks

HPSLDC Website : Brief Overview

The HPSLDC Website is interactive and is divided into two clear compartments – one for the general public, where anyone can access the information in the public domain, and the other requiring an authorized access to information.

The data is available online and real time on the website for public at large and the authorized users. For example any category of consumer can update himself about the Demand and Availability of Power for the next day. Also what has happened on the previous day can be accessed seamlessly and transparently.

The website has been designed in a simple manner with a focus on content. Keeping in mind the nature of the data and the importance of time to the end user, the use of heavy graphics, and animations, has been avoided.

Synchronization of elements and ease of use has been the prime focus while designing the website. The dynamic nature of data makes it imperative that the latest data is available on the website. Therefore the real time data is automatically updated every fifty seconds, and reports and other static data is manually updated as per the requirement (at least once a day before 12:00 noon). Add Your Remarks

Outline of the Functionalities

To access the DSS (Shakti), double-click on the SLDC HP icon on your Windows Desktop. A welcome screen as shown in the figure below will appear. This screen will stay for some time, but can be made to go away by clicking on the window.

You will be prompted to log in. Enter the User name and password in the window to continue.

User Name : ******
Password : ******
Server : ******

A window will appear on a successful log in. Click on Main in the menu bar and a drop down menu will appear. Click on financial year to choose the year applicable.

On clicking financial year a window as shown below will appear in which the current financial year can be chosen.

The following screen will appear. The following things can be seen in the screen.

1. Date and Revision No. of Drawal Schedule in force at the moment.

2. Drawal Schedule – Clicking on the button will take you to another screen where various revisions for the same day or previous days can be viewed.

3. Entitlement Schedules – Clicking on the button will take you to another screen where entitlement for the same day or previous days can be viewed.

4. Implemented Schedules – Clicking on the button will take you to a screen where the latest available Implemented schedules can be viewed.

5. GoHP Share Entitlement – Clicking on the button will take you to a different screen where GoHP entitlement in various projects can be calculated and viewed.

6. REA Comparison – Clicking on the button will take you to a different screen where GoHP share from various projects as reflected in the Implemented Schedule and All Transaction (Implemented) schedule are compared and displayed.

7. Day Ahead Schedule – Clicking on the button displays the day ahead for the current day and the previous days schedules can also be viewed.

Thus by using “Shakti” automation of the downloading, converting and report creation process has been facilitated, which in turn has made it convenient for the end user to focus on the important task of decision making and let the ICT handle the routine and error prone task of handling and processing the large amount of data. Add Your Remarks

Objective Targeted and Achieved

Output targeted: Automation of the processes to download /capture the data from the respective sources (main source: website of NRLDC and NREB & online data from the generating stations).

Objective achieved: Modules were developed to automate the process of download, and capture of the relevant data from the respective source.

Output targeted: Processing and analyzing the data

Objective achieved: This was achieved through automatic posting of the required data in the database for further processing and analysing. All the required reports (routine and MIS) were generated as per the requirement e.g. day-ahead schedule (frequency daily), Free and GoHP Power availability (frequency daily) Energy accounting reports (frequency monthly) etc. etc

Output targeted: Keeping the mind the end user of the software, it was desired that the software be easy to use (user friendly).

Objective achieved: A user friendly interface was developed to make the user experience as easy as possible.

Output targeted: Online presentation of the data captured and processed by Shakti. For example electrical power of about 2086 Million Units worth Rs. 1500 Cr. Transacted online in respect of Govt. of HP and neighbouring states of Punjab, Haryana, Rajasthan and Delhi.

Objective achieved: The data was put on the public domain through a Website. Add Your Remarks

DSS Shakti : An Overview

The manual capturing and processing of all the required data (online and off line modes from various sources) was almost impossible. When done manually, downloading and analyzing even a small amount of data was a cumbersome process. To further compound to the problem a large amount of data was available at random time points, and it was not possible to humanly track it all the time.

This data was also not available in the required form and to manually convert it into a usable form involved a lot effort on the part of the real time operators, who were already overburdened with the job of ensuring the smooth and safe operation of the Power Grid.

By the use of Shakti, the time taken to download and prepare the required reports was brought down to a minimum and with the least human effort. As soon as the data was available online, the software automatically downloads it, converts and stores it in the database in the required formats. The software also gives an audio alarm to the user to inform him that the data is ready and prepared for use.

Thus, by the use of Shakti, major bottlenecks (large amount of data, unusable formats, random time points, etc.) were removed and efficient decision making was facilitated. All stake holders, who were earlier unaware of the transactions till the reports had been prepared and compiled, can now access the data in real time. Add Your Remarks

Real Time Data

The biggest challenge of for the sensitive project Shakti at SLDC is capturing of real time data on various points. The Real Time and other required information is available online to all the stakeholders and beneficiaries.

HPSEB transaction with various constituents of NRPC are being processed and monitored by the use of “Shakti” software. For example, in the last six months 2086 Million Units of energy worth Rs. 1500 Cr and involving the processing and analysis of more than 27 crore records in respect of Government of Himachal Pradesh were transacted/ dispatched to the states of Punjab, Haryana, Rajasthan and Delhi.

Instantaneous processing of all the required transactions. As the updation and processing of the transaction is real time, therefore there are no time lags or delays in service outcomes.

Online information was put on the public domain of HPSLDC website (http://www.hpsldc.org) for its beneficiaries/stakeholders. Also, information on day ahead basis with respect to the demand and supply position in the state was put on the website for its usage by the consumers of the state. Add Your Remarks