|
GraphSheet software is the same patented software
used in Jackson Associates corporate energy marketing database products.
GraphSheet instantly transforms spreadsheet, database, word processor,
text or Web data into a free-form chart-based data exploration system.
Data visualization, drill-down, query, and navigation are all performed
with mouse clicks on charts. No special data setup is required, just
click and drag across a table and the analysis begins.
Extracting information from spreadsheets, report tables, databases and Web
data sets is tedious and time-consuming. Spreadsheets are the easiest and
most-used applications for extracting information from tables; however, even
with spreadsheets, setting up tables, sorting, using chart wizards then repeating
the process to follow new leads is cumbersome and frustrating. New techniques
like pivot tables and hypercubes just add to the confusion.
Spreadsheets like the one below don't reveal much information without a lot
of work.
Unless you apply GraphSheet, which instantly transforms tabular
data into charts packed with information and relationships covering the entire
database. Explore any part of the data, drill-down to any level of detail,
evaluate relationships and free the information locked away in spreadsheets
and databases.
The GraphSheet charts below were developed with just a few mouse-clicks.
GraphSheet's value has been proven in custom database applications at major
energy companies like the Southern Company, Enron, Commonwealth Edison,
Central and Southwest, DukeSolutions, Entergy, Cinergy and PG&E Energy
Service, at companies such as Toyota Motor Sales USA and at government
agencies such as the Defense Information Agency and Lawrence Berkeley
National Laboratory.
This same software used by our corporate clients in custom applications is
now available in a GraphSheet desktop version for use with your data. GraphSheet
can be applied to spreadsheet tables (Excel, Lotus 123, Quatro Pro), tables
in word processing software like Word, text tables, Web-downloaded text tables,
database tables (e.g., Access, Fox Pro, dBase, Paradox, etc.) and comma-delimited
export files which can be written from any industry-standard software.
A click-and-drag (or keyboard) selection of data in a table and a copy to
the clipboard is all that is required; GraphSheet reads data from the clipboard
and immediately begins an intuitive desktop OLAP (online-analytical processing)
session. No data setup is required.
-
Powerful OLAP analysis with no user setup.
-
A recently-patented intuitive, visual chart-based process that avoids
the need to learn separate query, charting and other data handling procedures.
You will be up and running in minutes.
-
Integration of all query, drill-down, data visualization and navigation
operations into a single process - all with mouse clicks on charts.
-
On-the-fly processing and unlimited access to all data - no preset
restrictions.
-
Point-and-click navigation on charts and dynamic query-tree nodes.
-
Documentation of chart operations in a the dynamically-developed query
tree to keep up with your queries and drill-downs.
-
Runs under Windows 3.x, Windows 95, 98 and Windows NT
-
Requires 16 MBytes of memory; 10 Mbytes of disk space
-
Processes tables with up to 5,000 rows of data
-
Data access from the clipboard
GraphSheet fits the needs of most users; however, if you need to access
larger tables or if you want other advanced capabilities in the
executive/power user version, see the description of
GraphSheetPRO.
GraphSheet uses the clipboard as an input platform; since nearly all software
transfers tabular data to the clipboard in a standard manner, GraphSheet
can immediately be applied from most software. Excel, Lotus 123, Quatro Pro,
Word, Notepad, and Web-downloaded text tables represent a few of the
GraphSheet-Compatible applications. Even data files that are not directly
accessible by GraphSheet can be converted to GraphSheet format. For instance,
data in an Access database cannot be read directly by GraphSheet; however,
Excel's query option enables users to develop Excel tables from the Access
database which can be copied to the clipboard and accessed by GraphSheet.
To use GraphSheet:
-
Open the application containing the table of interest (e.g., Excel),
-
Click and drag the mouse over any block of data in the table (including column
headings if desired),
-
Select Edit/Copy to copy the table data to the clipboard,
-
Open GraphSheet by clicking on the Graphsheet icon in the program group or,
if already open, Click on the GraphSheet icon in the program bar at the bottom
of the window to activate GraphSheet
-
Click on the GraphSheet Edit/Paste menu option and the GraphSheet session
begins.
Now you can:
-
Select any of the variables for chart display (a list-box is provided).
-
Use left-mouse clicks on charts to select any subset of the chart data (i.e.,
to perform a query).
-
Drill-down (double left-mouse click) to any subset of the chart data for
more focused analysis.
-
Move back to any previous position by clicking on a node in the query tree
window.
-
Apply other intuitive GraphSheet operations to visualize, navigate and understand
your data.
Most survey data (e.g., customer satisfaction surveys, association membership
surveys) collect a variety of data items from each survey respondent. These
data can be organized in a traditional row-column format where each row contains
all data items for a respondent with each data item residing in a separate
column. The spreadsheet displayed at the top of this page uses this format
to present results of a survey conducted on individual households.
Survey data organized in this form can immediately be analyzed with GraphSheet.
An example of survey data analysis is presented in the GraphSheet
Web Preview. GraphSheet provides a unique ability
to easily detect patterns and relationships in the sample of households included
in the survey data.
Certain kids of survey data; however, are traditionally much more difficult
to evaluate. These surveys include "record weights" which show how many members
of the population are represented by each sample respondent. Record weights
can be applied to this kind of survey data to provide information on the
entire population from which the survey sample was selected. For example,
if the weight for a sampled household is 10, that household represents itself
and nine other households who are similar. Weights can be applied to each
sample respondent to determine information on the entire population. If the
survey applied something other than a random sampling scheme, then the weights
may be different for different survey respondents. Processing and presenting
this kind of survey data can be exceedingly complicated; however, with
GraphSheet, analysis of weighted survey data is just as easy as the analysis
of any unweighted data.
If you don't currently process survey data which contains record or sampling
weights, you can skip the rest of this section. If you use weighted survey
data, you will be surprised at how much time you will save with GraphSheet
and how much more information can be developed from survey results.
To analyze survey data with record weights, include a column in the spreadsheet
table with the heading label "weight." When GraphSheet discovers the "weight"
label, it automatically accommodates weighted survey data, presenting population
results along with sample information in charts, tables and reports. Missing
value adjustments are made on-the-fly, providing easy and informative access
to all survey results. The following features describe GraphSheet
survey capabilities:
-
The "weight" variable in each record is automatically applied to each survey
variable to present population results in charts, tables and reports. Sample
size is also presented with population results.
-
Weighting can be turned on or off with a speed button to easily shift between
sample data and population data.
-
GraphSheet compensates for missing values on-the-fly. If you select a data
subset or variable combination that has missing values, GraphSheet automatically
recomputes and applies weights within each affected stratum to adjust for
the missing values.
GraphSheet survey capabilities can be applied with minimal setup. The following
process is most often used to access survey data: write the survey data to
a comma-delimited ascii text file, read the file into Excel and include a
column label named "weight" in the column containing the population weights.
If the survey data has missing values, replace the missing values with the
value -1e30. If the survey data uses a strata variable, include a column
label variable named "strata" in the column containing the strata numbers.
If you spend much time analyzing survey data, or if your surveys include
more than 5,000 records or 256 variables you will want to consider
advanced features provided in
GraphSheetPRO.
|
Demo
Download
