|
Profiler Software
Finally - bottom line information with just a few mouse clicks. 8760
and day-type electric hourly load profiles, customer and market characteristics
and more can now easily be developed for any industrial, commercial
or residential customer or customer segment anywhere in the country by
selecting virtually any combination of customer characteristics, any
state or service area with the MAISY Database Profiler
Software.
Over a year in development, the Profiler was designed to provide a "wizard"
approach to answering customer and market questions. Selection, processing
and weighting hundreds of variables and thousands of records is now
automated. (The standard MAISY chart-based drill-down process is available
for clients who license the full databases). The MAISY database profiler
systems also cost less than full MAISY database options because they apply
and present a subset of the full MAISY customer information resources.
Profiler software guides market segment/customer selection with a series
of twelve user-friendly forms. For example, the two images below show location
and commercial business type selection forms. Any user-specified market segment
or customer type can be selected by the user.
For Utility Service Area Database applications the following screen permits
selection of a service area for analysis.
Optionally, several additional forms like the one shown below can be used
to specify more detailed customer characterizations.
As indicated in the screen above, users can specify numeric entries for any
of the customer characteristics or select from broad categories.
A Summary of Profiler Customer
Characteristics Selections details selection categories for both residential
and commercial customers.
The Profiler software next extracts and processes relevant customer data
from the energy marketing and hourly loads databases and presents the results
in a Profiler Excel Workbook as illustrated below (screens shown below include
revenue and profitability which are optional data items and are not provided
in standard profiler applications).
This worksheet of the Profiler Workbook presents 8760 and day-type
hourly load profiles along with summary monthly energy use
characteristics. By clicking on the month radio buttons, users can quickly
evaluate load profiles over the entire year. The Workbook shown above also
includes profitability calculations based on utility rates and cost of service.
This information is an example of customized information and analysis which
can be provided in any client Profiler application.
The ability to quickly tab through monthly graphical presentations of hourly
loads and profits intuitively explains profit variations as a function of
hourly loads, rates and cost of service.
The Profiler also presents hourly load data in full chart and tabular
presentations in other Profiler Windows. Hourly load data can be exported
from the Profiler in text, CSV and other common export formats. The profitability
charts shown below reflect customized extensions applied in profitability
analysis.
The Profiler also presents hourly load data in full-sized chart and tabular
presentations in other Profiler Windows. Hourly load data can be exported
from the Profiler in text, CSV and other common export formats.
Two different kinds of analysis can be performed with the Profiler:
Customer - Focused Analysis provides results for an individual customer
or for an average customer from user-selected market segments depending on
the analysis application. User-selected market segments can range from the
entire market to highly detailed market subsets. Geographic location may
be the entire US, states or metropolitan areas. The tables and charts presented
above were developed as part of a customer analysis.
Total Market Analysis provides total customer counts, average energy
and hourly load profiles for all customers within a user-selected state market
segment. Output results include all of the energy and hourly load tables
and charts provided in the customer analysis and also include data on number
of customers within the market segment.
For instance customer-focused analysis can be applied to evaluate hourly
loads of a average office building in Pennsylvania while market analysis
can be applied to determine the total number of office customers in the state
along with their total electricity use and load profiles.
The results of each Profiler session are written to a separate Excel Workbook
file and include both tabular and chart presentations. The use of Excel Workbook
Profiler output files has a number of advantages; Excel Profiler files:
-
Promote sharing of analysis information in a familiar format
-
Provide easy-to-follow documentation of follow-on analysis via familiar
spreadsheet functions
-
Permit easy modification of tabular and chart presentations within Excel
-
Make it easy to compare results across multiple analysis sessions
All Profiler analysis results including detailed hourly load profiles can
be exported from Excel in standard CSV, text, XLS, and other file formats.
|
